In article <[EMAIL PROTECTED]>,
Nicholas Barr <[EMAIL PROTECTED]> wrote:
% Only copy the data directory if both servers are offline and not running
% and if both servers use the same version of postgres. This method is not
% recommended AFAIK.
It _is_ recommended for setting up a warm-standby ser
On Jun 25, 2007, at 10:44 , Nicholas Barr wrote:
Only copy the data directory if both servers are offline and not
running
and if both servers use the same version of postgres.
... and have the same architecture. As you note, copying the data
directory is *not* the recommended way to do th
Nicholas Barr writes:
It is much much safer to use pg_dump/pg_restore and know that your data is
consistent.
http://www.postgresql.org/docs/8.2/static/backup-dump.html
In particular look at the section
23.1.2. Using pg_dumpall
That will copy your entire data set including users.
-
> Hello, I have to move all the data in my actual server to the new one.
> I have several databases in postgresql, and I'd like to know the best way
> to
> move them.
> I thoung that maybe copying all the data directory... but I'm not sure,
> and I
> don't know where it's stored.
> I'd apreciate yo
Hello, I have to move all the data in my actual server to the new one.
I have several databases in postgresql, and I'd like to know the best way to
move them.
I thoung that maybe copying all the data directory... but I'm not sure, and I
don't know where it's stored.
I'd apreciate your help.
Than
