Change of the data directory on Ubuntu 7.04 - Mailing list pgsql-general

From Marek Szczypek
Subject Change of the data directory on Ubuntu 7.04
Date
Msg-id 20f94b14-952a-406f-9218-e5efcb3f23ce@e23g2000prf.googlegroups.com
Whole thread Raw
Responses Re: Change of the data directory on Ubuntu 7.04
List pgsql-general
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

pgsql-general by date:

Previous
From: Gordon
Date:
Subject: Postgres from PHP in Leopard
Next
From: Erik Jones
Date:
Subject: Re: Is there PHP mysql_real_escape_string for postgresql?