pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedrestore database files
3+ messages / 3 participants
[nested] [flat]
* restore database files
@ 2010-12-14 20:14 gosta100 <stathisgotsis@hotmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: gosta100 @ 2010-12-14 20:14 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: restore database files
@ 2010-12-16 07:57 Frederiko Costa <frederiko@gmail.com>
parent: gosta100 <stathisgotsis@hotmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Frederiko Costa @ 2010-12-16 07:57 UTC (permalink / raw)
To: gosta100 <stathisgotsis@hotmail.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: restore database files
@ 2010-12-25 07:41 Jasen Betts <jasen@xnet.co.nz>
parent: gosta100 <stathisgotsis@hotmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Jasen Betts @ 2010-12-25 07:41 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-12-25 07:41 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-12-14 20:14 restore database files gosta100 <stathisgotsis@hotmail.com>
2010-12-16 07:57 ` Frederiko Costa <frederiko@gmail.com>
2010-12-25 07:41 ` Jasen Betts <jasen@xnet.co.nz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox