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