[BUGS] Re: Installation problem "...The database cluster initialization failed.."

Hi! I have sent it in an e-mail to you. Unfortunately I only have it from the second, successful run of the installer. Best regards, Gunnar -- View this message in context: http://postgresql.1045698.n5.nabble.com/Installation-problem-The-database-cluster-initialization-failed-tp2130873p2807441

Re: [BUGS] BUG #5642: pg_upgrade does not handle shared libraries for language handlers

Thank you. I believe we had implemented version 6.x of Postgres back when Postgres had stored procedures, views, triggers, etc. and MySQL didn't. I said that I had no intention of using a database without views so we went with Postgres. Even our Configuration Management Software vendor has selec

Re: [BUGS] BUG #5642: pg_upgrade does not handle shared libraries for language handlers

"David Platt" writes: > No, that was defined in the database through pg_dump, edit the path, the > loading the pg_dump using psql. For each time the database has been > upgraded. > We started using Postgres in 2000 and even plpgsql had to be created as a > language back then, there was no creati

Re: [BUGS] BUG #5642: pg_upgrade does not handle shared libraries for language handlers

Postgres 8.4.1. The configure command was run with --prefix=/opt/postgres/8.4.1 and therefore the shared libraries are in /opt/postgres/8.4.1/lib. Same for 9.0rc1. The configure command was run with --prefix=/opt/postgres/9.rc1 and the shared libraries are in /opt/postgres/9.rc1/lib. -Ori

Re: [BUGS] BUG #5642: pg_upgrade does not handle shared libraries for language handlers

No, that was defined in the database through pg_dump, edit the path, the loading the pg_dump using psql. For each time the database has been upgraded. We started using Postgres in 2000 and even plpgsql had to be created as a language back then, there was no creation by default. Evidently the doc

Re: [BUGS] BUG #5642: pg_upgrade does not handle shared libraries for language handlers

Tom Lane wrote: > Bruce Momjian writes: > > David Platt wrote: > >> The following definition is my database: > >> > >> CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler > >> LANGUAGE c > >> AS '/opt/postgres/8.4.1/lib/plpgsql', 'plpgsql_call_handler'; > >> > >> The file /opt/postgr

Re: [BUGS] BUG #5647: COPY TO does not respect the [standard_conforming_strings] setting

Tom Lane wrote: > "David Sahagian" writes: > > Description:COPY TO does not respect the > > [standard_conforming_strings] setting > > This is not a bug. The COPY format is well defined and is not going to > be changed by standard_conforming_strings. Yes, remember COPY data are not "stri

Re: [BUGS] BUG #5642: pg_upgrade does not handle shared libraries for language handlers

Bruce Momjian writes: > David Platt wrote: >> The following definition is my database: >> >> CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler >> LANGUAGE c >> AS '/opt/postgres/8.4.1/lib/plpgsql', 'plpgsql_call_handler'; >> >> The file /opt/postgres/9.rc1/lib/plpgsql.o exists but

Re: [BUGS] BUG #5642: pg_upgrade does not handle shared libraries for language handlers

David Platt wrote: > > The following bug has been logged online: > > Bug reference: 5642 > Logged by: David Platt > Email address: davidpl...@davidplatt.com > PostgreSQL version: 9.0 RC1 > Operating system: CentOS 5.5 > Description:pg_upgrade does not handle shared li

Re: [BUGS] BUG #5646: missing chunk number 0 for toast

Alvaro Herrera writes: > Excerpts from Kevin Grittner's message of mar sep 07 11:56:32 -0400 2010: >> "missing chunk number" wrote: >>> ERROR: missing chunk number 0 for toast value 525559 in >>> pg_toast_325765 > Actually, we seem to get this particular report so often that I have my > doubts

Re: [BUGS] BUG #5629: ALTER SEQUENCE foo START execute a RESTART

Alexsander Rosa wrote: > What about the risk of using ALTER SEQUENCE ... START N in a mixed > environment? In the 8.4.x servers it will work as designed but in the 8.3.x > (and below) servers, instead of issuing an error it will CORRUPT the > sequence value without notice. I understand the point of

Re: [BUGS] BUG #5646: missing chunk number 0 for toast

Excerpts from Kevin Grittner's message of mar sep 07 11:56:32 -0400 2010: > "missing chunk number" wrote: > > > when i run my table in editor i faced this below error. > > Ex: select * from ad_role > > > > ERROR: missing chunk number 0 for toast value 525559 in > > pg_toast_325765 > > How can

Re: [BUGS] BUG #5640: ODBC driver installed but not found

On 8/09/2010 12:53 AM, Hannu Pohjanpalo wrote: > I did try the > c:\windows\system32\odbcad32 program, and pressed Add... but it does > not show any postgreSQL drivers. That's the 64-bit version of the ODBC administrator. Yes, that's confusing. The name is a holdover from the 16-bit to 32-bit

Re: [BUGS] Re: Installation problem "...The database cluster initialization failed.."

Hi, Can you please provide the install-postgres.log file found under %TEMP% directory. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company On Tue, Sep 7, 2010 at 1:06 PM, GunnarH wrote: > > Hi! > > I got exactly the same error messag

Fw: [BUGS] BUG #5640: ODBC driver installed but not found

Thanks Craig for your answer, and sorry for a late response. I did try the c:\windows\system32\odbcad32 program, and pressed Add... but it does not show any postgreSQL drivers. The driver I got installed by running Application Stack Builder 2.1.0 is psqlODBC v09.04.0200-1, and it was installed in

Re: [BUGS] BUG #5647: COPY TO does not respect the [standard_conforming_strings] setting

"David Sahagian" writes: > Description:COPY TO does not respect the > [standard_conforming_strings] setting This is not a bug. The COPY format is well defined and is not going to be changed by standard_conforming_strings. > I want to use the output file as input to psql, for another db

[BUGS] BUG #5647: COPY TO does not respect the [standard_conforming_strings] setting

The following bug has been logged online: Bug reference: 5647 Logged by: David Sahagian Email address: david.sahag...@gmail.com PostgreSQL version: 9.0 beta4 Operating system: win XP Description:COPY TO does not respect the [standard_conforming_strings] setting Detail

[BUGS] Re: Installation problem "...The database cluster initialization failed.."

Hi! I got exactly the same error message in Windows 7 with installer postgresql-8.4.4-1-windows.exe. The solution there seems to be to run the installer one more time and specify that the data folder should be a new folder, not placed within the postgreSQL installation. I put mine in C:\postgreS

Re: [BUGS] BUG #5646: missing chunk number 0 for toast

"missing chunk number" wrote: > when i run my table in editor i faced this below error. > Ex: select * from ad_role > > ERROR: missing chunk number 0 for toast value 525559 in > pg_toast_325765 > > ** Error ** > > ERROR: missing chunk number 0 for toast value 525559 in > pg_t

[BUGS] BUG #5646: missing chunk number 0 for toast

The following bug has been logged online: Bug reference: 5646 Logged by: missing chunk number Email address: chand.vi...@gmail.com PostgreSQL version: 8.3 Operating system: Linux Description:missing chunk number 0 for toast Details: Hi, when i run my table in editor

Re: [BUGS] BUG #5643: ecpg program doesn't process WHENEVER NOT DATA FOUND

On Sun, Sep 05, 2010 at 08:21:48AM +, Alexander Pyhalov wrote: > The following bug has been logged online: > > Bug reference: 5643 > ... Just for the record, this bug has been identified to show a local maybe FreeBSD related problem and not a PostgreSQL problem. Michael -- Michael Mes