pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump manual?
2+ messages / 2 participants
[nested] [flat]
* pg_dump manual?
@ 2001-08-30 20:56 Horace A. Vallas, Jr. <hav@hav.com>
0 siblings, 1 reply; 2+ messages in thread
From: Horace A. Vallas, Jr. @ 2001-08-30 20:56 UTC (permalink / raw)
To: pgsql-docs
I'm writing to this address because the links for mail lists fail and
said to write here if looking for docs and such...
I have some problem that is keeping me from being able to use
pg_dump or pg_dumpall on a 6.4 version. What I have found mentioned
about the error indicates either that my pg_xxxx applications are
the wrong versions for the database (very possible) or that there
is a problem with one or more table values (possibly but all databases
and tables on the machine fail to dump).
Trying to move to a 7.0 version
and simply moving the data dir from the old machine also will not seem
to work on the new...
SOOoooo - I guess I have to write my own pg_dump in order to get the
old data out --- but I don't know exactly what the format of pg_dump
and pg_dumpall might be --- nor which tables will actually be dumped
(for example, I can the the various pg_whatever tables in a base, but
I also see a bunch of tables named "regf12" and I have no idea what
those are or whether I should dump them in my pg_dump program)
Thanks for any pointers and/or docs to help me get this right -- there's
a BUNCH of data that can be lost if I cannot get it out of the old database.
--
Wishing you an "OOBA OOBA" 21st Century!!
Horace ...once known as "Kicker" :-)
================================================================
Horace Vallas hav.Software http://www.hav.com/
P.O. Box 354 hav@hav.com
Richmond, Tx. 77406-0354 voice: 281-341-5035
USA fax: 281-341-5087
Thawte Web Of Trust Notary in SW Houston, Tx.
http://www.hav.com/?content=/thawteWOTnotary.htm
================================================================
...drop by and chat if I'm online http://www.hav.com/chat/
=== === === === === === === === === === ====
What is a Vet? ... He is the barroom loudmouth, dumber than five
wooden planks, whose overgrown frat-boy behavior is outweighed a
hundred times in the cosmic scales by four hours of exquisite
bravery near the 38th parallel. ... - Unknown
================================================================
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_dump manual?
@ 2001-09-03 02:57 Christopher Kings-Lynne <chriskl@familyhealth.com.au>
parent: Horace A. Vallas, Jr. <hav@hav.com>
0 siblings, 0 replies; 2+ messages in thread
From: Christopher Kings-Lynne @ 2001-09-03 02:57 UTC (permalink / raw)
To: Horace A. Vallas, Jr. <hav@hav.com>; pgsql-docs
If you go pg_dump -? you should see a switch that tells pg_dump to run
regardless of version differences. Give that a shot.
Chris
> -----Original Message-----
> From: pgsql-docs-owner@postgresql.org
> [mailto:pgsql-docs-owner@postgresql.org]On Behalf Of Horace A. Vallas,
> Jr.
> Sent: Friday, 31 August 2001 4:56 AM
> To: pgsql-docs@postgresql.org
> Subject: [DOCS] pg_dump manual?
>
>
> I'm writing to this address because the links for mail lists fail and
> said to write here if looking for docs and such...
>
> I have some problem that is keeping me from being able to use
> pg_dump or pg_dumpall on a 6.4 version. What I have found mentioned
> about the error indicates either that my pg_xxxx applications are
> the wrong versions for the database (very possible) or that there
> is a problem with one or more table values (possibly but all databases
> and tables on the machine fail to dump).
>
> Trying to move to a 7.0 version
> and simply moving the data dir from the old machine also will not seem
> to work on the new...
>
> SOOoooo - I guess I have to write my own pg_dump in order to get the
> old data out --- but I don't know exactly what the format of pg_dump
> and pg_dumpall might be --- nor which tables will actually be dumped
> (for example, I can the the various pg_whatever tables in a base, but
> I also see a bunch of tables named "regf12" and I have no idea what
> those are or whether I should dump them in my pg_dump program)
>
> Thanks for any pointers and/or docs to help me get this right -- there's
> a BUNCH of data that can be lost if I cannot get it out of the
> old database.
>
>
> --
> Wishing you an "OOBA OOBA" 21st Century!!
> Horace ...once known as "Kicker" :-)
> ================================================================
> Horace Vallas hav.Software http://www.hav.com/
> P.O. Box 354 hav@hav.com
> Richmond, Tx. 77406-0354 voice: 281-341-5035
> USA fax: 281-341-5087
>
> Thawte Web Of Trust Notary in SW Houston, Tx.
> http://www.hav.com/?content=/thawteWOTnotary.htm
> ================================================================
> ...drop by and chat if I'm online http://www.hav.com/chat/
> === === === === === === === === === === ====
> What is a Vet? ... He is the barroom loudmouth, dumber than five
> wooden planks, whose overgrown frat-boy behavior is outweighed a
> hundred times in the cosmic scales by four hours of exquisite
> bravery near the 38th parallel. ... - Unknown
> ================================================================
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-09-03 02:57 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-08-30 20:56 pg_dump manual? Horace A. Vallas, Jr. <hav@hav.com>
2001-09-03 02:57 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox