Re: Moving data directory

Hi Ray,

Sorry for late reply. Yes, I have tested your instructions and working
well. The think is now I need to configure so that it will always
automically start with the new location.

Thank you very much for the detailed instructions, really appreciated it.

Regards,

Dino

On 5/14/07, Ray Stell <stellr(at)cns(dot)vt(dot)edu> wrote:
> On Sat, May 12, 2007 at 11:47:46PM +0700, Linux Geeks wrote:
> > I'm very new to postgresql and would like to move my data directory to
> > another partition in Ubuntu.
>
>
> I don't think there is anything internal to pg that locks the data
> location. Just tell postmaster where you move it to. Shut down the
> postmaster and move it and start it with the -D flag pointing to the
> new location:
>
> $ pg_ctl start -D /var/pgsql/data
> server starting
>
> $ psql -p 5437 testdb jira
> Password for user jira:
> Welcome to psql 8.2.3, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> testdb=> \q
>
> pg_ctl stop -D /var/pgsql/data
> waiting for server to shut down....,7222,,2007-05-13 19:52:06.675 EDT,,1,,, LOG: logger shutting down
> done
> server stopped
>
> $ mv /var/pgsql/data-move-test /var/pgsql/data
>
> $ pg_ctl start -D /var/pgsql/data-move-test
> server starting
>
> $ psql -p 5437 testdb jira
> Password for user jira:
> Welcome to psql 8.2.3, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> testdb=> \q
>
> pg_ctl stop -D /var/pgsql/data-move-test
> waiting for server to shut down....,7245,,2007-05-13 19:55:00.944 EDT,,1,,, LOG: logger shutting down
> done
> server stopped
>
> $ mv /var/pgsql/data-move-test /var/pgsql/data
>
> $ pg_ctl start -D /var/pgsql/data
> server starting
>
> $ psql -p 5437 testdb jira
> Password for user jira:
> Welcome to psql 8.2.3, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> testdb=> \q
>
> --
> Lost time is when we learn nothing from the experiences of life. Time
> gained is when we grow to have a wisdom that is tested in the reality of life.
>

--
To Analyze Is To Know Batte Field, Differ from Battle Itself