| From: | "Nicholas Barr" <nicky(at)chuckie(dot)co(dot)uk> |
|---|---|
| To: | Adrián Ribao MartÃnez <aribao(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Move a database from one server to other |
| Date: | 2007-06-25 15:44:01 |
| Message-ID: | 24916.62.244.190.66.1182786241.squirrel@www.chuckie.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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.
>
> Thank you very much.
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 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
Nick
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel T. Staal | 2007-06-25 15:44:20 | Re: another simple SQL question |
| Previous Message | Nicholas Barr | 2007-06-25 15:41:02 | Re: another simple SQL question |