Hello,
I don't know if this is a stupid question to ask or not, but I am
currently writing
a backup application for Postgres. I am using shell scripts using PSQL
to do
the actual dumps. I am incorparating the ability to completly customise
what
you want to backup from database to table level and to back up
seprately the
data and schema. I was considering breaking the shell scripts up too,
for both
readability and to keep the data dump code seperate from the
structure/schema
dump code.

What was wondering is with PSQL would I be able to run the data and the
schema
backup simultaniously? I would assume that one would fail due to the
fact a
backup is already being run on that same table? if not would there be
much
diffrence in the backups being simultaniously as opposed to
sequentially?

I know there are probably lots of pre-build system to backup postgres
avaliable
but its a bit of fun and quite interesting learning curve

Many thanks
David Phillips

"Fuzzydave" <dav.phillips (AT) ntlworld (DOT) com> schreef in bericht
news:1166709315.002317.204830 (AT) 80g2000cwy (DOT) googlegroups.com...

Be aware of locks that may hold [insert or update] queries

Further you may end up NOT backupping the definition of indexes,
restrictions and defaults, as well as both the definition and current value
of sequences.


Just my 2ct

HansH

pg_dumpall

so
it shouldn't be an issue.


of the same table, I want to back up the database/schema/table
structure,
permission etc seperately from the actually database/schema/table data.


on the table structure as it retains all the permissions, user groups
and logins
etc ... but now that I think about it can I do pg_dumpall at
schema/table level
too? I am currently using a combination of pg_dumpall and pg_dump.


Muchly Appreciated merry christmas
David P

Fuzzydave <dav.phillips (AT) ntlworld (DOT) com> wrote:
Either I do not really understand what you are trying to do, or you are
on a wrong track.

You do not call pg_dump from psql.

Using the appropriate options of pg_dump and pg_dumpall you should
be able to dump only the data you want:

The --globals-only option of pg_dumpall will dump only those things that
pg_dump won't (roles, role memberships and tablespaces).

With pg_dump, you can use --schema and --table to export only individual
schemata and tables.

Is that not enough for what you have in mind?

Yours,
Laurenz Albe