Re: pg_dump on remote machine

From: Thomas Kaminski <kaminski(at)univention(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump on remote machine
Date: 2005-04-08 14:20:47
Message-ID: 1112970047.31501.21.camel@anton.knut.univention.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

> Iam trying to take a dump of my DB from one machine to another in
this
> fashion:
>
> on the secondary database:
>
> pg_dump -b -h 172.16.1.20 (dbname) > /tmp/dump.dump

Can you get connect with
psql -h 172.16.1.20 (dbname)

I think, you /etc/pg_hba.conf must be configured to grant this access.
And don't forget to reload the postmaster after this.

Look in the log of postgresql.

Bye Thomas

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David A. Leedom 2005-04-08 18:14:20 Automatic Backups
Previous Message Brad Nicholson 2005-04-08 14:20:43 Re: pg_dump on remote machine