Re: Moving the database from a filesystem to another

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: csegyud(at)vnet(dot)hu
Cc: "Pgsql-General(at)Postgresql(dot)Org (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Moving the database from a filesystem to another
Date: 2003-12-12 17:08:28
Message-ID: 20485.1071248908@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-2?Q?Egy=FCd_Csaba?= <csegyud(at)vnet(dot)hu> writes:
> Is it enough to copy/move the directory /var/lib/pgsql/data to eg.
> /data/pgsql/data and set $PGDATA to that directory?

Yes. Shut down postmaster *before* starting the move, though.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2003-12-12 17:19:50 Re: Change date format only for one DB
Previous Message Bret Busby 2003-12-12 17:06:03 Re: [NOVICE] PostgreSQL Training