| From: | Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu> |
|---|---|
| To: | pgsql(at)halfahead(dot)dk |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Constructing a backup routine |
| Date: | 2001-12-20 08:44:41 |
| Message-ID: | Pine.LNX.4.21.0112200939440.4809-100000@pc10.radnoti-szeged.sulinet.hu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
In our production state system we usually do this:
$ pg_dump -xacnDO database_name | grep "^SELECT setval "
This gives SQL statements which can be reloaded into an arbitrary
database. A bit slow, IMHO a clever select on the system tables should
give you the same result much faster.
HTH, Zoltan
--
Kov\'acs, Zolt\'an
kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu
http://www.math.u-szeged.hu/~kovzol
ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Archibald Zimonyi | 2001-12-20 08:56:07 | Connections? |
| Previous Message | Peter T. Brown | 2001-12-20 02:58:37 | controlling process priority |