From: | "Leonel Nunez" <listas(at)enelserver(dot)com> |
---|---|
To: | "Marek Szczypek" <markacy(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Change of the data directory on Ubuntu 7.04 |
Date: | 2007-12-20 15:37:03 |
Message-ID: | 36616.189.155.232.130.1198165023.squirrel@enelserver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
you can leave the instalation as is , and create a tablespace in
/dane/postgresql and create your databases in the NEW tablespace
take a look at :
http://www.postgresql.org/docs/8.2/static/manage-ag-tablespaces.html
Leonel
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2007-12-20 15:42:21 | Re: Postgres from PHP in Leopard |
Previous Message | Gordon | 2007-12-20 15:35:49 | Re: Postgres from PHP in Leopard |