PgSql

ERROR: incompatible library
Hello lists, I am trying to run Slony on a Master Postgres 8.1.11 replicating to a Slave same version and 2nd Slave Postgres 8.3.4. The purpose is to update Postgres in production by steps, first slaves then switchover to upgrade the master that will not be master when upgraded. I am getting the f... 13 Nov 2008 07:26

8.3 .4 + Vista + MingW + initdb = ACCESS_DENIED
Charlie Savage wrote: I'm trying to upgrade my copy of postgresql from 8.2.x to 8.3.4 on a Windows Vista SP1 laptop. I build postgres using mingw/msys and have had no issues with 8.1.x and 8.2.x. However, with 8.3.4 I run into problems. First, building fails: c:/Development/MingW/bin/../lib/gcc/... 13 Nov 2008 08:36

"\ef <function>" in psql
Abhijit Menon-Sen <ams(a)oryx.com> writes: Refactoring pg_dump was more work than I had time to do right now, and I wanted \ef to work, so I hacked up the attached (by copying dumpFunc and its dependencies to src/bin/psql/dumpfunc.[ch]). I doubt we'd consider accepting a patch done this way. regards, to... 4 Aug 2008 13:37

Building under Visual Studio 2008 - pqcomm.c compile error
"Knight, Doug" <dknight(a)wsi.com> writes: I am attempting to build postgres 8.3.3 under Visual Studio 2008, and I get the following error in the build: .\src\backend\libpq\pqcomm.c(389): error C2065: 'IPPROTO_IPV6' : undeclared identifier [ squint... ] They define IPV6_V6ONLY and AF_INET6 but not IPPR... 14 Jul 2008 14:44

LD_LIBRARY_PATH not honored on Debian unstable
Hi, I'm trying to run 'make check' on a 64bit Debian unstable. That aborts after 60 seconds due to not being able to connect to the postmaster. I figured that there's nothing wrong with the postmaster, rather psql can't start up, because it gets linked against an older libpq.so.5. It looks like for some rea... 9 Jan 2008 09:22

Possible PostgreSQL 8.3beta4 bug with MD5authentication in psql?
On Fri, 2007-12-07 at 11:03 -0500, Tom Lane wrote: Hmmm ... it seems the problem is that we've defined PQconnectionUsedPassword in such a way that it returns true (causing a prompt) regardless of whether the reason for the connection failure was a bad password or not. We might need to reconsider that API... 10 Dec 2007 01:38

xlogdump
There's an xlogdump project on pgfoundry. However it suffers from perennial bitrot as it has to maintain its own table of xlog record types and code to decode each xlog record type. Earlier I modified xlogdump to generate a CSV loadable data set so I could do some basic analysis and see what types of operations... 10 Nov 2007 09:10

pgadmin debug on windows
Hello, I've installed on a windows xp machine beta 1 of postgresql 8.3 and pgadmin III 1.8. I've loaded a backup of a database from a 8.2.5 machine, for testing purpose, and tried the new functionality of plpgsql debug of functions. But I was disappointed to see that does not work. I try to debug right clickin... 25 Oct 2007 05:14

rolcanlogin vs. the flat password file
There's a gripe over here http://archives.postgresql.org/pgsql-general/2007-10/msg00640.php to the effect that PG should not give a message like "password authentication failure" when the user is attempting to log in as a NOLOGIN role. This surprised me because there is a specific message for that, and it worked ... 23 Oct 2007 14:46

CREATE DATABASE cannot be executed from a function or multi-command string
Dave Page wrote: I get the above error message when creating a database in pgAdmin now: CREATE DATABASE demo WITH ENCODING='SQL_ASCII' TABLESPACE=pg_default; COMMENT ON DATABASE demo IS 'This is the demo database'; GRANT ALL ON DATABASE demo TO public; ALTER DATABASE demo SET search_pa... 24 Sep 2007 06:36