pgSql 7.4.rc2
--- Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> If you you pg_dump and dump schema and data together, then there is some
> magic to temporarily disable foreign key constraints. Try it out.
Dunno. Don't see any magic so far. In fact, pg_restore appears to use
internally the same S
there is any utility or command for compare two databases,
tables structure (schema).
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Maybe you can use :
pg_dump -s -t Thetable firstdatabasename > first
pg_dump -s -t Thetable seconddatabasename > second
diff first second
Bruno
Ashok Chauhan wrote:
there is any utility or command for compare two databases,
tables structure (schema).
---(end of broad
Here's a question about that: Do dumps always occur
in a predictable row order?
If it is not the case, then you might need to sort each
table dump before the diff.
yuji
On Sun, 16 Nov 2003, Bruno LEVEQUE wrote:
> Maybe you can use :
>
> pg_dump -s -t Thetable firstdatabasename > first
>
ow writes:
> --- Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> > If you you pg_dump and dump schema and data together, then there is some
> > magic to temporarily disable foreign key constraints. Try it out.
>
> Dunno. Don't see any magic so far. In fact, pg_restore appears to use
> internally th
--- Peter [EMAIL PROTECTED]> wrote:
>
> Read again. No one was talking of pg_restore.
Perhaps I should clarify.
First, I ran pg_dump to extract schema and data *together*. Then I ran
pg_restore to restore the db. It took about 1 hour to create tables and copy
the data, then about 40 min to crea
Where can we place wishes for PostgreSQL v7.5 and 8.0 ??? Is it
pgsql-hackers ???
---
Oli Sennhauser
Database-Engineer (Oracle & PostgreSQL)
Rebenweg 6
CH - 8610 Uster / Switzerland
Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14
e-Mail [E
On Sun, 16 Nov 2003, ow wrote:
> --- Peter [EMAIL PROTECTED]> wrote:
> >
> > Read again. No one was talking of pg_restore.
>
> Perhaps I should clarify.
>
> First, I ran pg_dump to extract schema and data *together*. Then I ran
> pg_restore to restore the db. It took about 1 hour to create tables
--- Stephan Szabo <[EMAIL PROTECTED]> wrote:
> Only assuming that no changes were made between dump and restore. This
> could be changes to schema or data done manually, but it could also be a
> locale or possibly encoding change if you have any textual foreign keys.
I'm restoring the database,
On Sun, 16 Nov 2003, ow wrote:
>
> --- Stephan Szabo <[EMAIL PROTECTED]> wrote:
> > Only assuming that no changes were made between dump and restore. This
> > could be changes to schema or data done manually, but it could also be a
> > locale or possibly encoding change if you have any textual fo
RedHat 9 ships with Postgres so there should be no incompatibilities.
However, there has been an errata issued and an updated rpm is available
at https://rhn.redhat.com/errata/rh9-errata.html. I always download the
source and compile my own though to get an optimized build.
-Original Message-
--- ow <[EMAIL PROTECTED]> wrote:
> Perhaps I should clarify.
>
> First, I ran pg_dump to extract schema and data *together*. Then I ran
> pg_restore to restore the db. It took about 1 hour to create tables and copy
> the data, then about 40 min to create indexes, then pg_restore spent 4.5
> hours
Hi ow,
When your using expensive support, like this email list, technical
replies can take some time.
Perhaps those who can help you are on the other side of the globe and
are sleeping.
Or maybe they busy trying to make a living.
Please be patient.
If you do not recieve a reply I suggest you po
13 matches
Mail list logo
