Postgres Pro
Downloads
Home   >   mailing lists

Re: Moving the database from a filesystem to another - Mailing list pgsql-general

From Tom Lane
Subject Re: Moving the database from a filesystem to another
Date
Msg-id 20485.1071248908@sss.pgh.pa.us
Whole thread Raw
In response to Moving the database from a filesystem to another  (Együd Csaba <csegyud@vnet.hu>)
List pgsql-general
Tree view 
=?iso-8859-2?Q?Egy=FCd_Csaba?= <csegyud@vnet.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

pgsql-general by date:

Previous
From: Miso Hlavac
Date:
Subject: Change date format only for one DB
Next
From: Peter Eisentraut
Date:
Subject: Re: Change date format only for one DB