Postgres Pro
Downloads
Home   >   mailing lists

Thread: initdb and WARN

initdb and WARN

From
Andrea Antibo
Date:
when I run initb it show me this message:


initdb: using /usr/local/pgsql/lib/local1_template1.bki.source as input to
create the template database.
initdb: using /usr/local/pgsql/lib/global1.bki.source as input to create the
global classes.
initdb: using /usr/local/pgsql/lib/pg_hba.conf.sample as the host-based
authentication control file.

We are initializing the database system with username postgres (uid=26).
This user will own all the files and must also own the server process.

initdb: creating template database in /usr/local/pgsql/data/base/template1
Running: postgres -boot -C -F -D/usr/local/pgsql/data -Q template1
WARN:heap_modifytuple: repl is \  0
initdb: could not create template database
initdb: cleaning up by wiping out /usr/local/pgsql/data/base/template1


I loocked on the web and now I know I must delete the old library of postgres,
but, i did it.
I deleted all in old pgsql home, I created a new home.

And now?

RE: [ADMIN] initdb and WARN

From
Andrea Antibo
Date:
> I loocked....


oppssss... sorry  :-))))

Re: [ADMIN] initdb and WARN

From
Bruce Momjian
Date:
> when I run initb it show me this message:
>
>
> initdb: using /usr/local/pgsql/lib/local1_template1.bki.source as input to
> create the template database.
> initdb: using /usr/local/pgsql/lib/global1.bki.source as input to create the
> global classes.
> initdb: using /usr/local/pgsql/lib/pg_hba.conf.sample as the host-based
> authentication control file.
>
> We are initializing the database system with username postgres (uid=26).
> This user will own all the files and must also own the server process.
>
> initdb: creating template database in /usr/local/pgsql/data/base/template1
> Running: postgres -boot -C -F -D/usr/local/pgsql/data -Q template1
> WARN:heap_modifytuple: repl is \  0
> initdb: could not create template database
> initdb: cleaning up by wiping out /usr/local/pgsql/data/base/template1
>
>
> I loocked on the web and now I know I must delete the old library of postgres,
> but, i did it.
> I deleted all in old pgsql home, I created a new home.

Old binaries in search path.  I have added a mention of this exact error
message in the FAQ.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: [ADMIN] initdb and WARN

From
Andrea Antibo
Date:
>> initdb: creating template database in /usr/local/pgsql/data/base/template1
>> Running: postgres -boot -C -F -D/usr/local/pgsql/data -Q template1
>> WARN:heap_modifytuple: repl is \  0
>> initdb: could not create template database
>> initdb: cleaning up by wiping out /usr/local/pgsql/data/base/template1
>>
>>
>> I loocked on the web and now I know I must delete the old library of
>> postgres,
>> but, i did it.
>> I deleted all in old pgsql home, I created a new home.
>
> You have an old version of the postgres binaries in your search path.


This is the .bashrc of user postgres but I deleted all before new installation.


PATH=$PATH:/usr/local/pgsql/bin
MANPATH=$MANPATH:/usr/local/pgsql/man
PGLIB=/usr/local/pgsql/lib
PGDATA=/usr/local/pgsql/data
export PATH MANPATH PGLIB PGDATA