Randall Smith <[EMAIL PROTECTED]> writes:
> As a note, using pg_dump with plain text format does not have this
> problem. So is there a bug in the custom format?
Not in general, but feel free to show us a reproducible test case...
regards, tom lane
-
Randall Smith wrote:
I'm dumped a database on 7.4.0.3 using pg_restore -Fc mydb > mydb.dump.
I then restored it using pg_restore -d dwstest -U dba mydb.dump on
another server running 7.4.5-3.
After importing, all of the sequences are set to 0. Did I miss a step?
Randall
As a note, using pg_dump
Thank you Tom.
So in my case, where should I start? I want to be able to dump this
database to a new machine. Given my corruption, how should I go about
this? My current plan is to use Slony, but I'm worried that the
corruption will interfere with the transfer.
How can I get the db server to simp
I'm dumped a database on 7.4.0.3 using pg_restore -Fc mydb > mydb.dump.
I then restored it using pg_restore -d dwstest -U dba mydb.dump on
another server running 7.4.5-3.
After importing, all of the sequences are set to 0. Did I miss a step?
Randall
---(end of broadcast)-
Dan Hrabarchuk <[EMAIL PROTECTED]> writes:
> I'm not getting the documented behaviour.
The documented behavior is that zero_damaged_pages changes the response
to (detectably) damaged page headers. It is not a magic cureall for
every form of data corruption.
regards, tom l
Hi
Can someone point me in the right direction on where to start?
I'm not getting the documented behaviour. If this is not the correct
list, I'll ask else where.
Below is the entry quoted from the online manual for 7.3:
ZERO_DAMAGED_PAGES (boolean)
Detection of a damaged page
unsuscribe
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
alwin <[EMAIL PROTECTED]> writes:
> So far so good. But the current code uses queries without quotes, like
> select * from Table; and not select * from "Table";.
You have a problem :-(
> Is there an easier fix for this? Does the SQL92/SQL3/SQL2003 specify
> unquoted table names to be case-insensi
Dear mailing list,
I'm trying to convert a MsSQL database to a Postgres database, with DTS i can
convert the data between the databases. DTS creates case sensitive tables
(using quotes), exactly like i want it to be.
So far so good. But the current code uses queries without quotes, like
select * fr
