[ADMIN] Migration from 7.4.2 to 8.1.4

Hi!   I'm an administrator of a big company who has a PgSQL-database version 7.4.2. We would like to upgrade it to 8.1.4 but the dump we made cannot be restored. We got a lot of error messages while restoring database related on something's being restored before other objects would exists. (

[ADMIN] Correct JDBC driver for

Hello,One of our Java developers is having trouble inserting data to postgres 7.4.13 (running on Gentoo linux). The Java version being used is 1.4.The proble is with 'backslash_quote = off' the database is rejecting the data sent from the Java application. Within the application we don't use " \ "

Re: [ADMIN] Migration from 7.4.2 to 8.1.4

Am Montag, 21. August 2006 11:43 schrieb Gallai János: > I'm an administrator of a big company who has a PgSQL-database version > 7.4.2. We would like to upgrade it to 8.1.4 but the dump we made cannot be > restored. We got a lot of error messages while restoring database related > on something's b

Re: [ADMIN] Migration from 7.4.2 to 8.1.4

On Mon, Aug 21, 2006 at 11:43:28AM +0200, Gallai János wrote: > I'm an administrator of a big company who has a PgSQL-database > version 7.4.2. We would like to upgrade it to 8.1.4 but the dump > we made cannot be restored. Which version of pg_dump/pg_dumpall did you use? When upgrading use the n

[ADMIN] unsubscribe

Juan Pablo Grassi __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

[ADMIN] Vacuum issues..

Hi,   I am using PostgreSQL 8.1.4 for an embedded application.  For some reason, vacuum is not able to identify rows that are candidates for removal (i.e., mark space as available).   Background Info:   I observed some performance problems – our database seemed to be using an unusuall

Re: [ADMIN] Vacuum issues..

Eamonn Kent wrote: I am using PostgreSQL 8.1.4 for an embedded application. For some reason, vacuum is not able to identify rows that are candidates for removal (i.e., mark space as available). [snip] If I shutdown our application and run a vacuum full, the space is recovered and the databa

[ADMIN] unsubscribe

Unsubscribe R Mohan ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[ADMIN] Max User Connections

Hi, I have set Max Connection parameter as 1000 in Postgres.conf file. But it only allows max connections to be 155. I have increased Shared buffer parameter also. I am not able to find out a solution to this problem. I have searched in the archives as well. Do I need to increase the Shared mem

[ADMIN] unsubscribe

Unsubscribe Jayaram ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq