> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
