Hi,
I am trying to create a daily backup cron script but it fails with an error
as below:
Any pointers to resolve this will be greatly appreciated.
Thanks,
Mitesh Shah
mitesh.s...@stripes39.com
*(1) Error:*
bash-3.2$ sh pg_backup_rotated_orig.sh
Making backup directory in
There used to be a switch in pg_dump that would disable the version, you can
even see that's in the man page. However, it is not reccommended and the most
recent versions have fully deprecated the switch. Technically speaking that
means that you can even use an older version of pg_dump and it
Dear admin,
I have successfully set up the stream replication M1--IP1, M2---IP2, my
question is if the master is down, the slave will become read and write by
trigger file, but the client will connect to the IP2,right?
Thanks,
Song
On Thu, 2012-05-03 at 13:47 +0800, sgm wrote:
I have successfully set up the stream replication M1--IP1, M2---IP2,
my question is if the master is down, the slave will become read and
write by trigger file, but the client will connect to the IP2,right?
No. You will need something else (like
Hi,
Recently, in our Production server, we found a single query being held up
in IDLE in transaction for more than 19 hours using the following query:
select date_trunc('second', current_timestamp - query_start) as runtime,
datname as database_name, current_query from pg_stat_activity where
On Thu, 3 May 2012 15:48:35 +0530, Gnanakumar wrote:
Hi,
Recently, in our Production server, we found a single query being
held up
in IDLE in transaction for more than 19 hours using the following
query:
[...]
Usually these are application problems, not database ones. E.g. a piece
of code
Gnanakumar wrote:
Recently, in our Production server, we found a single query being
held up
in IDLE in transaction for more than 19 hours using the following
query:
select date_trunc('second', current_timestamp - query_start) as
runtime,
datname as database_name, current_query from
Using postgres 9.0.7 on RHEL 5.4. I have a parent table that is partitioned by
day. My inserts are working correctly and are being directed to the correct
child table. I also have both an UPDATE and DELETE trigger on the parent table
that are defined as AFTER triggers. The actual update and
Plugge, Joe R. jrplu...@west.com wrote:
Using postgres 9.0.7 on RHEL 5.4. I have a parent table that is
partitioned by day. My inserts are working correctly and are
being directed to the correct child table. I also have both an
UPDATE and DELETE trigger on the parent table that are