[BUGS] Known issues for PostgreSQL server 8.1.19
Hi, We are using PostgreSQL server 8.1.19 in our product and as part of SDLC activities, we would like to know about the Known Issues present in this version. Regards, Anurag Dashputre
[BUGS] BUG #8463: Packaging problem with postgis rpms
The following bug has been logged on the website: Bug reference: 8463 Logged by: Kriton Kyrimis Email address: kyri...@alumni.princeton.edu PostgreSQL version: 9.2.4 Operating system: Scientific Linux 6.4 Description: (I am submitting this report here, as I assume that the rpms downloaded from yum.postgresql.org are built by postgresql and not by postgis.) The latest release of the postgis2_92* rpms (version 2.0.4) introduced a new package, postgis2_92-client, containing, among other things, the postgis shared library. This creates the problem that, after updating an existing system, the shared libraries disappear, and postgis stops working, producing the error "postgis2_92-client-2.0.4-1" whenever a query involving postgis is executed. At the very least, the postgis2_92 package should depend on the postgis2_92-client package, so that updating the former will also install the latter, thus avoiding breaking existing systems. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #8462: psql is trying to access the unix socket in wrong directory
The following bug has been logged on the website: Bug reference: 8462 Logged by: Felipe Diefenbach Email address: felipe.diefenb...@dbseller.com.br PostgreSQL version: 9.2.4 Operating system: Ubuntu 12.04 LTS Description: installed postgres apt repositories for the site, changed connections pg_hba.conf to trust, and when I try to connect it says unable to access the unix socket in / tmp, although the configuration file postgresql.conf the default directory is / var / run / postgresql. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #8461: PostgreSQL 9.3 pg_dump heap corruptions
The following bug has been logged on the website: Bug reference: 8461 Logged by: Benjamin Wassermann Email address: be...@hegne.de PostgreSQL version: 9.3.0 Operating system: Windows Description: Hi! We are trying to build our own PostgreSQL 9.3 using Visual Studio 2005 on Windows XP. If we use the created pg_dump we get some “Heap Corruptions” and no database dump will be created. When we use the precomiled binaries from PostgreSQL 9.3 and use this pg_dump we do NOT get any heap corruption and it works as expected. To reproduce the bug you need a Microsoft Visual Studio 2005 with Version 8.0.50727.42. Buildsteps: 1. Download the postgresql sources 9.3 2. Open a visual studio commandline and change to folder "postgresql-9.2.3\src\tools\msvc". Execute the command "perl mkvcbuild.pl" (make sure "ActivePerl" is installed, where using version "5.12.2 Build 1202"). 3. In the root folder is now a pgpsql.sln, which u can open in visual studio 4. Now change the "Build-Target" to Release 5. Now build the Projects in following steps and configuartions libpgport: General > Use of MFC: "Use MFC in a Static Libary" Libarian: Ingore Specific Libary "Nafxcwd.lib" and "Libcmtd.lib" -> Build libpqtypes: General > Use of MFC: "Use MFC in a Static Libary" -> Build libpq: General > Use of MFC: "Use MFC in a Static Libary" Linker > Additional Dependencies: "ShFolder.lib" and "Advapi32.lib" -> Build libecpg: General > Use of MFC: "Use MFC in a Static Libary" -> Build libpgcommon: General > Use of MFC: "Use MFC in a Static Libary" -> Build psql: General > Use of MFC: "Use MFC in a Static Libary" Linker > Additional Dependencies: "Advapi32.lib" Rename the Function _dosmaperr to _test_dosmaperr -> Build If there is a error like: "ERROR: psqlscan.c could not be found" just do the following: Open a commandline and call "flex.exe "\postgresql-9.2.3\src\bin\psql\psqlscan.l" (http://gnuwin32.sourceforge.net/install.html). Now copy the created file to "\postgresql-9.2.3\src\bin\psql\psqlscan.c". -> Build pg_dump: General > Use of MFC: "Use MFC in a Static Libary" Linker > Additional Dependencies: "Advapi32.lib" and "zlib.lib" (path example with default installation: "C:\Programme\GnuWin32\lib\zlib.lib") C/C++ > Preprocessor Definitions: "HAVE_LIBZ" C/C++ > Additional Include Directories: C:\Programme\GnuWin32\include -> Build Now we have installed a PostgreSQL Server 9.3 on the same machine. In Visual Studio we defined as "Command Arguments" the following: "-h "localhost" -p 5432 -U postgres -f "C:\test.bak" -F c test" Now start debugging and u will get the Heap corruption in Visual Studio. Exactly u will get the following ASSERTION: --- Microsoft Visual C++ Debug Library --- Debug Assertion Failed! Program: ... File: dbgheap.c Line: 1252 Expression: _CrtIsValidHeapPointer(pUserData) For information on how your program can cause an assertion failure, see the Visual C++ documentation on asserts. (Press Retry to debug the application) --- Abbrechen Wiederholen Ignorieren --- Which is caused from the Function "dumpFunc" at line 9942 ff. ... free(funcsig); ... Hope you can reproduce this Bug. Is there a workaround we could use? Regards Benjamin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Known issues for PostgreSQL server 8.1.19
Hi, On 2013-09-18 11:56:36 +, Dashputre, Anurag (GE Healthcare) wrote: > We are using PostgreSQL server 8.1.19 in our product and as part of SDLC > activities, we would like to know about the Known Issues present in this > version. The primary issue - especially regarding lifecycle - is that 8.1 is out of support and thus unmaintained for more than 2 years. Check http://www.postgresql.org/support/versioning/ for details. The also have been several maintenance releases with important fixes in the 8.1 line since then. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8463: Packaging problem with postgis rpms
Hi, Thanks for the report. I created http://wiki.pgrpms.org/ticket/141 to track this bug. There is another critical ticket pending for RHEL 6 packages, so expect the new package pretty soon. Regards, Devrim On Wed, 2013-09-18 at 13:56 +, kyri...@alumni.princeton.edu wrote: > The following bug has been logged on the website: > > Bug reference: 8463 > Logged by: Kriton Kyrimis > Email address: kyri...@alumni.princeton.edu > PostgreSQL version: 9.2.4 > Operating system: Scientific Linux 6.4 > Description: > > (I am submitting this report here, as I assume that the rpms downloaded from > yum.postgresql.org are built by postgresql and not by postgis.) > > > The latest release of the postgis2_92* rpms (version 2.0.4) introduced a new > package, postgis2_92-client, containing, among other things, the postgis > shared library. This creates the problem that, after updating an existing > system, the shared libraries disappear, and postgis stops working, producing > the error "postgis2_92-client-2.0.4-1" whenever a query involving postgis is > executed. > > > At the very least, the postgis2_92 package should depend on the > postgis2_92-client package, so that updating the former will also install > the latter, thus avoiding breaking existing systems. > > > -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
