Hi All, I have a question - what is the procedure, to change the default location of the data directory of PostgreSQL database? I would like the data to be stored in /dane/postgresql/data instead of the Ubuntu's default location (/var/lib/postgresql/). Is it enough just to run initdb -D /dane/postgresq/data, and set in .bashrc file of the postgres user PGDATA variable to /dane/postgresql/data, and maybe to move configuration files to /etc/postgresql/8.2/main (just as ubuntu does when installing the database)? Thanks in advance for answers and hints :-) Cheers, Marek ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
