pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRemote Backup (pg_dump_all) Windows/Linux.
3+ messages / 3 participants
[nested] [flat]
* Remote Backup (pg_dump_all) Windows/Linux.
@ 2014-01-08 17:15 Renato Forti <re.tf@acm.org>
0 siblings, 2 replies; 3+ messages in thread
From: Renato Forti @ 2014-01-08 17:15 UTC (permalink / raw)
To: pgsql-admin
Hi All,
I have one question about backup (pg_dump_all).
If anyone can helpeme!
I have one pg running on linux (x64), and I want take one backup of it. But
from a windows machine (x32) . A remote backup!
I can do this? The pg need be same version and bitness on windows and linux?
Any other advise?
What command option (pg_dump_all) I can use to do this?
Thanks
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Remote Backup (pg_dump_all) Windows/Linux.
@ 2014-01-08 18:02 Walter Hurry <walterhurry@gmail.com>
parent: Renato Forti <re.tf@acm.org>
1 sibling, 0 replies; 3+ messages in thread
From: Walter Hurry @ 2014-01-08 18:02 UTC (permalink / raw)
To: pgsql-admin
On Wed, 08 Jan 2014 15:15:42 -0200, Renato Forti wrote:
> I have one pg running on linux (x64), and I want take one backup of it.
> But from a windows machine (x32) . A remote backup!
>
>
>
> I can do this? The pg need be same version and bitness on windows and
> linux?
pg_dumpall (no second underscore)
I don't think it needs to be the same bitness, but certainly the same
version would seem sensible.
It would be slow, though. How big are your databases? Why not just run it
on the Linux box?
--
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: Remote Backup (pg_dump_all) Windows/Linux.
@ 2014-01-09 02:07 Sergey Konoplev <gray.ru@gmail.com>
parent: Renato Forti <re.tf@acm.org>
1 sibling, 0 replies; 3+ messages in thread
From: Sergey Konoplev @ 2014-01-09 02:07 UTC (permalink / raw)
To: Renato Forti <re.tf@acm.org>; +Cc: pgsql-admin
On Wed, Jan 8, 2014 at 9:15 AM, Renato Forti <re.tf@acm.org> wrote:
> I have one question about backup (pg_dump_all).
pg_dumpall
> I have one pg running on linux (x64), and I want take one backup of it. But
> from a windows machine (x32) . A remote backup!
>
> I can do this? The pg need be same version and bitness on windows and linux?
> Any other advise?
This is an SQL dump so it does not need to be on the same
architecture. The only recommendation is the same or later version.
> What command option (pg_dump_all) I can use to do this?
Here you will find the pg_dumpall docs
http://www.postgresql.org/docs/current/interactive/app-pg-dumpall.html
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray.ru@gmail.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
end of thread, other threads:[~2014-01-09 02:07 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-01-08 17:15 Remote Backup (pg_dump_all) Windows/Linux. Renato Forti <re.tf@acm.org>
2014-01-08 18:02 ` Walter Hurry <walterhurry@gmail.com>
2014-01-09 02:07 ` Sergey Konoplev <gray.ru@gmail.com>
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