[ADMIN] cannot get error message after dblink_exec execution

Hi, I am using DBLink contrib module. I cannot catch the dblink_exec error messages. On the other hand, the pgadmin gui shows the error message under "DETAIL" section: The test function : CREATE OR REPLACE FUNCTION test_func1() RETURNS integer AS $$ DECLARE stmt text; conn

[ADMIN] when inserting to table, text type parameter become NULL (after big assignment to this parameter)

Hi, I am trying to get server parameters (pg_settings) using a cursor and insert them to one column table. A stored procedure parameter holds the long string. The insert of this parameter does not fail. The problem is that the string (the parameter value) is not inserted to the tabl

[ADMIN] how can I drop database though user connections to it (force drop)

Hi, I need to drop database. "drop database" does not always work, since user connections to the database still exist (I get : ERROR: database "yuval" is being accessed by other users , SQL state: 55006) How can I force the drop ? or is there a way to kill database connection and then to

[ADMIN] odbc problem on Japanese windows machine

Hi, I am trying to use postgres odbc driver on windows Japanese machine, to test connection to a remote postgres database. The database has latin1 encoding. Connection tests to databases with latin1 encoding fail with this error message: fatal: conversion between SJIS and LATIN1 is n

[ADMIN] get PGDATA as non-postgres user

Hi I need to get PGDATA location when I logged in as non-postgres user. I cannot see data_directory from pg_setting table as non-postgres user. Any work around? Any other way to retrieve that information? If not, what is the quickest way to enable non-postgres user to have PGDATA l

[ADMIN] how do I get table DDL from psql (not from pg_dump)

Hi I need to extract table DDL (create script) from database connection (using sql, by retrieving system table info or by activating some pg function) Is this possible in postgres? Please help Thanks Yuval Sofer BMC Software CTM&D Business Unit DBA Team 972-52-4286-282 [EMAI

[ADMIN] problem with pg_stat_activity view

Hello, postgres version: 8.2.0.4 platform windows: server 2008 I check connections using: SELECT pg_stat_get_backend_idset() Now, I take the output and try to get the ip addresses using select pg_stat_get_backend_client_addr(); but for a local connection (simple login us

[ADMIN] compilation test fails

Hi, I have compiled 8.3.7 on HP-Itanium After the build I have continued to the tests (gmake check) One of the tests failed (division by zero error test) The regression.diffs file shows the diff regarding of the expected result and the actual result: *** ./expected/errors.out Sat Nov 10 1

[ADMIN] Unknown winsock error 10061

Hi, Postgres server crashed on windows vista. From the log: 2010-04-07 07:00:35.694 LOG: could not receive data from client: Unknown winsock error 10061 2010-04-07 07:00:35.694 LOG: could not receive data from client: Unknown winsock error 10061 2010-04-07 07:00:35.694 LOG: unexpected EOF o

[ADMIN] postgres crashes - "not reattach to shared memory "

Hi Postgres crashes with - PG "FATAL: could not reattach to shared memory (key=5432001, addr=0210): Invalid argument. The version is 8.2.4, the platform is win32 Does someone know the reason/workaround ? Thanks, Yuval Sofer BMC Software CTM&D Business Unit DBA Team 972-52-4286-282 yuv

[ADMIN] Postgres service starts and then stops immediatly

Hi, -We are using Postgres 8.3.7 on Windows -We cannot start the Postgres service. The windows OS error message is: "The PostgreSQL Server 8.3 service on Local Computer started then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts

[ADMIN] Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help

Hi, I am using Postgres DB with stand by database, configured with streaming in synchronized mode (each commit on primary DB waits for commit on secondary DB). Sometimes we suffer from network issues and as consequences, secondary machine is not available. In these situations, our applic