[ADMIN] Re: Restoring a pg_dump fails with

2001-04-29 Thread Anuradha Ratnaweera
Will vacuumdb help? On Fri, 27 Apr 2001, Tom Lane wrote: > Reiner Dassing <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> That shouldn't happen. Could we see the dump file? (Just the schema > >> commands, not the data itself...) > > > Thank you for your help. Certainly I will give this

[ADMIN] Re: Reason to not upgrade from 6.5 to 7.0 or above

2001-04-29 Thread Anuradha Ratnaweera
On Wed, 25 Apr 2001, Joel Burton wrote: > Is there anything that datetime did that timestamp doesn't? datetime is provided to ensure compatibility with older releases, although they are not guranteed to exist in future releases (chapter 3.4 users guide) > Could you > >pg_dump | sed | ps

[ADMIN] Re: 7.1 performance

2001-04-29 Thread Anuradha Ratnaweera
I had to run a script which did few thousand queries on 7.1 few times and after that even the queries that are done entirely based on indexes were also _VERY_ slow. But I did a "vacuumdb dbname" as postgres user and after that thigs were back to normal - very fast. But I could _NOT_ reproduce th

[ADMIN] disable wal

2001-04-29 Thread Anuradha Ratnaweera
Is there a way to disable write ahead logging (WAL) in 7.1? Thanks in advance. Anuradha ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [ADMIN] disable wal

2001-04-29 Thread Oliver Vecernik
Anuradha Ratnaweera wrote: > > Is there a way to disable write ahead logging (WAL) in 7.1? Why do you want to do this? Oliver ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Restoring a pg_dump fails with

2001-04-29 Thread Reiner Dassing
Hello Tom! > Perhaps there is some configuration or platform issue here? What were > your configure options? The options were as follows: ./configure --with-pgport=5432 \ --with-x \ --with-perl \ --with-python \ --with-tcl \ --enable-odbc \