[GENERAL] Alternate location

2000-03-22 Thread Stefano Bargioni
Hi, I need to define a very large db in a disk partition /data that is not the default partition of Postgres. The Chapter 10 of the admin guide describes a procedure that fails (postgres 6.5.3): $ PGDATA2=/data $ initlocation $PGDATA2 We are initializing the database area with username postgres

Re: [GENERAL] Alternate location

2000-03-22 Thread Peter Eisentraut
On Wed, 22 Mar 2000, Stefano Bargioni wrote: $ PGDATA2=/data $ initlocation $PGDATA2 initlocation PGDATA2 We are initializing the database area with username postgres (uid=40). This user will own all the files and must also own the server process. $ createdb -D $PGDATA2 ucc2 createdb -D

Re: [GENERAL] Alternate location

2000-03-22 Thread Stefano Bargioni
Peter Eisentraut wrote: On Wed, 22 Mar 2000, Stefano Bargioni wrote: $ PGDATA2=/data $ initlocation $PGDATA2 initlocation PGDATA2 We are initializing the database area with username postgres (uid=40). This user will own all the files and must also own the server process. $

Re: [GENERAL] Alternate location

2000-03-22 Thread Peter Eisentraut
On Wed, 22 Mar 2000, Stefano Bargioni wrote: Dear Peter, thank you, the manual has an error: in the initlocation command, the $ must be deleted; but there is still a problem with createdb: Yes, thank you. $ createdb -D PGDATA2 ucc2 ERROR: Unable to locate path 'PGDATA2/ucc2' This