On Fri, Apr 27, 2012 at 7:14 AM, leo xu wrote:
> i have one parimary ,two standby. one standby using stream replication
pg_archivecleanup doesn't work with more than one standby feeding from
a single archive
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development,
Lonni J Friedman wrote:
> I'm running postgresql-9.1.3 on a Linux-x86_64 (Fedora16, if it
> matters) system. I noticed the existence of pg_basebackup starting in
> 9.1, and figured I'd try it out and see if it would simplify our
> backup & management processes.
>
> $ pg_basebackup -P -v -D /tmp/b
leo xu wrote:
> I test postgresql database performance recently,i set
> log_min_duration_statement=1000;
> i monitor pg_log file,i find too many execue S_2:commit
> 10.0.44.21:30170:2012-04-28 11:38:46.340 CSTLOG: duration: 1050.679
ms
> execute S_2: COMMIT
>
> 10.0.44.21:30208:2012-04-28 11:
Alexander Reichstadt wrote:
> Thanks, I had checked the example before but couldn't make sense out
of it in terms of wrapping it in
> Objective-C. I left it in C now and it works fine.
>
> The trigger I am using now looks like this:
>
> CREATE FUNCTION notify_trigger() RETURNS trigger AS $$
>
>
Thank you. You don't get the error, because you called FOR EACH ROW EXECUTE,
which I didn't. I fixed it, it all works now!
Am 30.04.2012 um 14:58 schrieb Albe Laurenz:
> CREATE TRIGGER t1_trig AFTER INSERT OR UPDATE OR DELETE ON t1
> FOR EACH ROW EXECUTE PROCEDURE notify_trigger();
signatur
Thanks, I had checked the example before but couldn't make sense out of it in
terms of wrapping it in Objective-C. I left it in C now and it works fine.
The trigger I am using now looks like this:
CREATE FUNCTION notify_trigger() RETURNS trigger AS $$
DECLARE
BEGIN
IF ( TG_OP = 'INSERT' ) THE
Thanks, I had checked the example before but couldn't make sense out of it in
terms of wrapping it in Objective-C. I left it in C now and it works fine.
The trigger I am using now looks like this:
CREATE FUNCTION notify_trigger() RETURNS trigger AS $$
DECLARE
BEGIN
IF ( TG_OP = 'INSERT' ) THE
Hi,
>From the documentation I was able to build a trigger firing upon deletion of a
>record a function that delivers tablename_operation as a notification one
>needs to subscribe to. So in terminal I can say LISTEN persons_delete and
>instantly will receive
Asynchronous notification "p
Alexander Reichstadt wrote:
> From the documentation I was able to build a trigger firing upon
deletion of a record a function that
> delivers tablename_operation as a notification one needs to subscribe
to. So in terminal I can say
> LISTEN persons_delete and instantly will receive
>
> Asyn
Hi Guys, I got the support from Greenplum. I will give a feedback to
everybody after I test. Thanks.
They told me to add in /etc/rc.d.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-to-set-up-automatically-startup-database-when-the-server-boot-or-reboot-tp5670442p
Here are additional details (in addition to the original post) on what I
am trying to do with a single update statement:
Suppose three tables:
1) person
2) person_home
3) group
1) table: person 3) table: group
column:person_id column: grou
Alexander Reichstadt writes:
> But what I don't fully understand is how to do this with PQnotifies.
> Following the docu I get no notifications even though I subscribe to them
> after successfully connecting to the server the same way I do using terminal.
Maybe you forgot PQconsumeInput? There
On Mon, Apr 30, 2012 at 1:47 AM, Alexander Reichstadt wrote:
> Hi,
>
> From the documentation I was able to build a trigger firing upon deletion of
> a record a function that delivers tablename_operation as a notification one
> needs to subscribe to. So in terminal I can say LISTEN persons_delet
These odbc drivers (psqlodbc-08.02.0400 psqlodbc-08.03.0400
psqlodbc-09.00.0200 psqlodbc-08.02.0500 psqlodbc-08.04.0200) were
installed. But I can't fine where the odbc.ini. After I set up my .odbc.ini.
And setup the driver and driver manager environment variables, I still can't
get the isql com
I'm running a postgresql 8.1 database on a single server which is queried from
a number of client systems.
Both server and clients are running Debian Linux.
I need to upgrade from 8.1 to 8.3, but it's difficult for me to upgrade
everything at once. Is it possible to
run different versions of th
On 04/30/2012 11:34 AM, roy hills wrote:
I'm running a postgresql 8.1 database on a single server which is
queried from a number of client systems.
Both server and clients are running Debian Linux.
I need to upgrade from 8.1 to 8.3, but it's difficult for me to
upgrade everything at once. Is i
On 4/30/2012 1:34 PM, roy hills wrote:
I'm running a postgresql 8.1 database on a single server which is
queried from a number of client systems.
Both server and clients are running Debian Linux.
I need to upgrade from 8.1 to 8.3, but it's difficult for me to upgrade
everything at once. Is it po
On Mon, Apr 30, 2012 at 12:32 PM, leaf_yxj wrote:
> These odbc drivers (psqlodbc-08.02.0400 psqlodbc-08.03.0400
> psqlodbc-09.00.0200 psqlodbc-08.02.0500 psqlodbc-08.04.0200) were
> installed. But I can't fine where the odbc.ini. After I set up my .odbc.ini.
> And setup the driver and driver man
Hi Scott,
I amn't farmiliar with isql. Why I said isql is because that I did some
research. they said something related to isql. No matter it's isql or psql.
1)How can I test the odbc function?
2) what's isql, in which circumstances , we use isql.
Thanks.
Regards.
Grace
At 2012-05-01
>you want psql not isql.
On Mon, Apr 30, 2012 at 3:19 PM, yxj wrote:
> Hi Scott,
>
> I amn't farmiliar with isql. Why I said isql is because that I did some
> research. they said something related to isql. No matter it's isql or psql.
>
> 1)How can I test the odbc function?
> 2) what's isql, in w
Hello,
We were auditing our logs on one of our PG 9.0.6 standby servers that we use
for nightly snapshotting. The high-level process is:
1. Stop PG
2. Snapshot
3. Start PG
Where "Snapshot" includes several steps to ensure data/filesystem integrity.
The archive command on the master continues t
Hi There,
While trying to restore a ~700GM binary dump by command
pg_restore -d dbdata < sampledbdata-20120327.pgdump
I encountered following errors repeatedly
pg_restore: [archiver (db)] Error from TOC entry 2882463; 2613
10267347 BLOB 10267347 sdmcleod
pg_restore: [archiver (db)] could not ex
Hi Chris,
Actually I only want to test ODBC. But I didn't have any idea to test. We have
pgsqlodbc installed, but I don't how to test it. Please give me some clue.
Thanks.
Grace
At 2012-05-01 03:54:36,"Chris Curvey" wrote:
>you want psql not isql.
On Mon, Apr 30, 2012 at 3:19 PM, yxj w
Hi Guys:
I installed this odbc driver :psqlodbc-08.02.0400
and datadirect-x_xx. I want to test this two things work or not.
Please give me some idea.
Thanks.
Grace
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Test-ODBC-connection-failed-Pleae-help-me-to-take-a-loo
Hi Guys,
Have 9.1.3 running with Postgis 2.0 . Trying to add PR/R and getting some
errors about my postgres install. I found some similar messages, but none
with a workable solution for me. Any thoughts are very appreciated.
I am running* USE_PGXS=1 make* in my PLR directory and it returns:
*
On 04/30/12 8:04 PM, Daniel Cole wrote:
Have 9.1.3 running with Postgis 2.0 . Trying to add PR/R and getting
some errors about my postgres install. I found some similar messages,
but none with a workable solution for me. Any thoughts are very
appreciated.
I am running/*USE_PGXS=1 make*/ in
On 04/30/12 8:22 PM, John R Pierce wrote:
On 04/30/12 8:04 PM, Daniel Cole wrote:
Have 9.1.3 running with Postgis 2.0 . Trying to add PR/R and getting
some errors about my postgres install. I found some similar
messages, but none with a workable solution for me. Any thoughts are
very apprec
On 04/30/2012 06:31 PM, John R Pierce wrote:
>> On 04/30/12 8:04 PM, Daniel Cole wrote:
>>> I am running/*USE_PGXS=1 make*/ in my PLR directory and it returns:
>>>
>>> /Makefile:36: /usr/lib/postgresql/9.1/lib/pgxs
>
>
> oops, on the RHEL6 yum install, thats
>
> /usr/lib/postgresql/9.1/lib/p
28 matches
Mail list logo
