[GENERAL] New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..."

2011-12-16 Thread Patrick Kevin McCaffrey
Hello, First off, sorry if this has been received by everyone already. I sent it last night, and got an error about not being a list member, so I joined, and am resending it now. I'm new to PostgreSQL, but am trying to set up a server on my machine. The PostgreSQL server is to run inside of

[GENERAL] PQreset needs to be executed twice to really connect to the postgresql database

2011-12-16 Thread ChoonSoo Park
Here is my sample code and I had to execute PQreset twice to connect to the database after asynchronous command ( PQsendQueryParams ). #include #include #include using namespace std; boolcheckStatus(PGconn* conn, bool readable, bool writable, int second, int microsecond) { int sock =

[GENERAL] disable autovacuum per-database?

2011-12-16 Thread Mike Blackwell
I'd like to temporarily disable autovacuum on a single database while it is being loaded. Is there an easy way to do this? __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelle

Re: [GENERAL] question about \encoding option of psql

2011-12-16 Thread Adrian Klaver
On Thursday, December 15, 2011 10:33:03 pm Xiaobo Gu wrote: > Hi Adrian, > > I am on the Windows platform, how should I paste the command line. I don't use Windows enough to be sure but: http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/echo.mspx?mfr=true So open a

[GENERAL] Permission denied on relation

2011-12-16 Thread Radosław Smogura
Hi, I get following error from pgAdmin base/16547/29877 Permission denied on Windows, when opening database statistics. I almost sure how to reproduce this error, but it only works on one database. It's mix of following steps mainly in this order. In any way bug is not always sure, but chance

Re: [GENERAL] Vacuum and Large Objects

2011-12-16 Thread Igor Neyman
From: Simon Windsor [mailto:simon.wind...@cornfield.me.uk] Sent: Wednesday, December 14, 2011 3:02 PM To: pgsql-general@postgresql.org Subject: Vacuum and Large Objects Hi I am having problems recovering storage from a Postgres 9.05 database that is used to hold large XML blocks for a week, bef