Re: [GENERAL] Help, server doesn't start

2012-06-25 Thread Craig Ringer
On 06/25/2012 09:27 PM, Alban Hertroys wrote: Yes, pg_dump output from 8.3 should restore fine to 9.1. Pardon my ignorance if this changed in recent versions, but shouldn't that read: Yes, pg_dump 9.1 output from 8.3 should restore fine to 9.1? Very good point and an important catch. Thank-you.

Re: [GENERAL] Help, server doesn't start

2012-06-25 Thread Alban Hertroys
> Yes, pg_dump output from 8.3 should restore fine to 9.1. Pardon my ignorance if this changed in recent versions, but shouldn't that read: Yes, pg_dump 9.1 output from 8.3 should restore fine to 9.1? -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest.

Re: [GENERAL] Help, server doesn't start

2012-06-25 Thread Craig Ringer
On 06/25/2012 08:02 PM, Anibal David Acosta wrote: We plan to upgrade to version 9.1, do you know if file result of the pg_dump in 8.3 can be restored in 9.1? Yes, pg_dump output from 8.3 should restore fine to 9.1. PLEASE READ THE RELEASE NOTES for the intermediate major versions (8.4 and

Re: [GENERAL] Help, server doesn't start

2012-06-25 Thread Anibal David Acosta
havendra'; pgsql-general@postgresql.org Asunto: Re: [GENERAL] Help, server doesn't start On 06/25/2012 12:40 PM, Anibal David Acosta wrote: Yes, we must upgrade. The value of the shared_preload_libraries is shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll

Re: [GENERAL] Help, server doesn't start

2012-06-25 Thread Anibal David Acosta
postgresql.org Asunto: Re: [GENERAL] Help, server doesn't start On 06/25/2012 12:40 PM, Anibal David Acosta wrote: Yes, we must upgrade. The value of the shared_preload_libraries is shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' # (c

Re: [GENERAL] Help, server doesn't start

2012-06-24 Thread Craig Ringer
On 06/25/2012 12:40 PM, Anibal David Acosta wrote: Yes, we must upgrade. The value of the shared_preload_libraries is shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' # (change requires restart) Change that to: shared_preload_libraries = '' (two single quotes, not a doubl

Re: [GENERAL] Help, server doesn't start

2012-06-24 Thread Raghavendra
On Mon, Jun 25, 2012 at 10:10 AM, Anibal David Acosta wrote: > Yes, we must upgrade. > > The value of the shared_preload_libraries is > > ** ** > > shared_preload_libraries = > '$libdir/plugins/plugin_debugger.dll' # > (change requires restart) > > ** > F

Re: [GENERAL] Help, server doesn't start

2012-06-24 Thread Anibal David Acosta
aghavendra@enterprisedb.com] Enviado el: lunes, 25 de junio de 2012 12:31 a.m. Para: Anibal David Acosta CC: pgsql-general@postgresql.org Asunto: Re: [GENERAL] Help, server doesn't start On Mon, Jun 25, 2012 at 8:23 AM, Anibal David Acosta wrote: We have an old postgres installation (

Re: [GENERAL] Help, server doesn't start

2012-06-24 Thread René Romero Benavides
El 24/06/2012 11:30 p.m., René Romero Benavides escribió: El 24/06/2012 09:53 p.m., Anibal David Acosta escribió: We have an old postgres installation (8.3) running on windows 2003 The server run perfect for many years but today it crash L We have a very old backup so I'll try desperate to re

Re: [GENERAL] Help, server doesn't start

2012-06-24 Thread Raghavendra
On Mon, Jun 25, 2012 at 8:23 AM, Anibal David Acosta wrote: > We have an old postgres installation (8.3) running on windows 2003 > > The server run perfect for many years but today it crash L > > ** ** > > We have a very old backup so I’ll try desperate to repair. > > If I can’t repai

Re: [GENERAL] Help, server doesn't start

2012-06-24 Thread René Romero Benavides
El 24/06/2012 09:53 p.m., Anibal David Acosta escribió: We have an old postgres installation (8.3) running on windows 2003 The server run perfect for many years but today it crash L We have a very old backup so I'll try desperate to repair. If I can't repair I want to skip the error and start