Thread: restore database files
Hello everyone, I have a copy of the data folder of a Windows postgres installation. Is it possible to restore the databases contained in there to another postgres server? Thank you. -- View this message in context: http://postgresql.1045698.n5.nabble.com/restore-database-files-tp3305210p3305210.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Yes, it is. Have a look at pg_dump utility. The documentation contains plenty of examples.
On Tue, Dec 14, 2010 at 12:14 PM, gosta100 <stathisgotsis@hotmail.com> wrote:
Hello everyone,
I have a copy of the data folder of a Windows postgres installation. Is
it possible to restore the databases contained in there to another postgres
server?
Thank you.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/restore-database-files-tp3305210p3305210.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On 2010-12-14, gosta100 <stathisgotsis@hotmail.com> wrote: > > Hello everyone, > > I have a copy of the data folder of a Windows postgres installation. Is > it possible to restore the databases contained in there to another postgres > server? yes, you'll need to correct the permissions on the files and run copy them onto an equivalent version of postgres for windows. -- ⚂⚃ 100% natural