python api to backup/restore data
I am working with Postgresql 8.2.4 and Python 2.5.
I would like to know whether an API for accessing Postgresql from
Python exists and whether or not it supports commands for backing up a
database (or schema) and restoring a backup file.
I heard about psycopg and psycopg2 but have no idea of how to use them
for backup/restore operations.
Thank you.
Acm <alextabone@gmail.com> writes:
I would like to know whether an API for accessing Postgresql from
Python exists and whether or not it supports commands for backing up a
database (or schema) and restoring a backup file.
Run pg_dump or pg_restore as a subprocess.
regards, tom lane
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 08/04/07 10:58, Tom Lane wrote:
Acm <alextabone@gmail.com> writes:
I would like to know whether an API for accessing Postgresql from
Python exists and whether or not it supports commands for backing up a
database (or schema) and restoring a backup file.Run pg_dump or pg_restore as a subprocess.
But that doesn't give you the capability of getting customized output.
- --
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFGtMMQS9HxQb37XmcRArvxAKDo0VQvq1uBtCEUYYb3+FSWNKmCYACfckSV
f7gaTsz/mAbEzFH0IJIypI0=
=WAls
-----END PGP SIGNATURE-----