[SQL] 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

[SQL] compile postgres with visual studio 2010

Hi I would like to build Postgres from source with the visual studio 2010 compiler Is it supported? Is there any document which describes the process of the implementation? Thanks, Yuval Sofer BMC Software CTMD Business Unit DBA Team 972-52-4286-282 yuval_so...@bmc.com -- Sent via

Re: [SQL] regexp_replace and search/replace values stored in table

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 CTMD Business Unit DBA Team 972-52-4286-282

[SQL] 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(integer); but for a local connection (simple

[SQL] 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 CTMD Business Unit DBA Team 972-52-4286-282

[SQL] 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 succeeds. The problem is that the string (the parameter value) is not inserted to the table.