On 02/06/2013 08:09 AM, Dev Kumkar wrote:
Hello Everyone,
I am using postgres 9.2 and when executing function dblink facing a
fatal error while trying to execute dblink_connect as follows:
/SELECT * FROM dblink_connect('host=127.0.0.1 port=5432
dbname=postgres password=test')/
*ERROR*:
kunal sharma wrote:
Hi ,
We are using Postgres 8.4 and its been found going into
recovery mode couple of times. The server process seems to fork
another child process which is another postgres server running under
same data directory and after some time it goes away while the old
Amit jain wrote:
Dear All,
I am having a backup file in tar format. While restoring it through
pg_restore instantly i am getting an following error.
*Command - pg_restore -d cipa
/cipa/RAJASTHAN/RAJASTHAN/CIPABACKUP01_08_2008.TAR
Error - pg_restore: [archiver] out of memory
*I have
Pattu, Susanta Kumar wrote:
Hello,
I am trying to install postgresql-8.2.4 on (Remote Server) with
Windows Server 2003 (pack 1).
I use the postgresql-8.2.msi installer with:
- national language support, PL/java, Development files selected
- install a service option checked with postgres
Leaving aside the question of why one might want to do this, Unix 101
should show you many ways to do it. For example,
sed -n -e 's/.*PG_VERSION /PG_VERSION /p' -e /PG_VERSION/q config.log
Please don't cross-post questions like this, especially when it's not
really a PostgreSQL question at
Mageshwaran wrote:
Hi ,
Any body tell me how to kill a long running query in postgresql, is
there any statement to kill a query, and also tell me how to log slow
queries to a log file.
First. please do not cross-post like this. Pick the correct list and use it.
Second, this query
Joe Conway wrote:
Tom Lane wrote:
Well, *Marc* is working on including less stuff; the rest of us don't
necessarily agree. In particular I've got to re-incorporate any major
pieces that get removed from the core distribution, since people expect
to find those in the RPM set. (In principle I