[GENERAL] Dumping database using 8.1 or 7.1

2006-08-03 Thread Jonathan Vallar
Hi! I have a corrupt database that runs on Postgres 7.1.2. I was able to repair the database where I can now connect to the database and do queries. I have a migration plan to transfer my database to a Postgres 8.1. I encountered problems when I was dumping the database. Postgres 7.1 reported: ge

Re: [GENERAL] Dumping database using 8.1 or 7.1

2006-08-04 Thread Jonathan Vallar
tables. Some lines on the file are empty (a blank record or a corrupt record?). Before the said lines, there was a "\M". What does "\M" stand for?Thanks in advance. Regards,JonathanOn 8/4/06, Jaime Casanova <[EMAIL PROTECTED]> wrote: On 8/3/06, Jonathan Vallar <[EMAIL

Re: [GENERAL] Dumping database using 8.1 or 7.1

2006-08-07 Thread Jonathan Vallar
Thanks sir.   Is it safe to use the Postgres 8.1.4 pg_dump utility to dump data from a postgres 7.1.2 database?   Thanks again :)   Jonathan Valllar  On 8/5/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Jonathan Vallar" <[EMAIL PROTECTED]> writes: > After dumping the databa

Re: [GENERAL] Dumping database using 8.1 or 7.1

2006-08-08 Thread Jonathan Vallar
ed procs.The pg_dump utility returns an error that it cannot dump missing triggers but are still at the database catalogue. Does this mean that I really cannot dump my database?Thanks!Regards,JonathanOn 8/8/06, Alvaro Herrera < [EMAIL PROTECTED]> wrote: Jonathan Vallar wrote:> Thanks sir.>