pg_dump when used with chroot - Mailing list pgsql-general

From Sumita Biswas
Subject pg_dump when used with chroot
Date
Msg-id 039401c46542$8bc88e00$dc656540@amer.cisco.com
Whole thread Raw
In response to Re: Function with RETURN TYPE RECORD Called From JAVA  ("Carl E. McMillin" <carlymac@earthlink.net>)
List pgsql-general
Hi All,

I am facing an issue with pg_dump, please let me know if there is a
solution to this.

I have a database called 'car' on one partition , on which I have the
Postgres Server running.
When I run a script from another partition on the same machine, which
does a pg_dump, the pg_dump is unable to find the car database.
The reason here might be the pg_dump command is run as chroot and chroot
is /partB.
The car database is on /.
So the pg_dump command tries to find a car database on /partB, which
does not exist.

Is there a way by which I can run the pg_dump from a different root, and
make it backup a database on a different root?
Regards,
Sumita


pgsql-general by date:

Previous
From: o.blomqvist@secomintl.com (Otto Blomqvist)
Date:
Subject: SSL Problems: invalid connection option "requiressl"
Next
From: Plant Thomas
Date:
Subject: Problem pg_restore from 7.3 to 7.4