tch value.
I'm assuming that idx_tup_read would probably be the best choice, but
want to get other opinions before proceeding.
Can anyone point me to docs which explain this better?
-salman
---(end of broadcast)---
TIP 9: In versions below 8
doesn't have to have anything in it. The script
simply checks to see if the file exists, and if it does, the recovery
loop is stopped.
-salman
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
libra dba wrote:
continuing with the postgres replication using WARM STANDBY, what happens to
the wal_files which keeps on generating on the primary?
Do we have to manually remove them or they are removed automatically, once
they have been recovered on the warm standby?
Also a quick question,
libra dba wrote:
Hey Salman,
Thanks a lot for all your guidance and help. It has really been a great
help. I appreciate your quick replies.
Which replication in postgres is better ?
SLONY or WARM STANDBY (usning wal).
I use both. Between our two production machines, we replicate data with
Marc Fromm wrote:
We have a database that we use each year.
Each year the database needs to be free of any data from the past year.
We need to retain last years data base with its data.
I tried using template:
CREATE DATABASE 'year2007-2008' TEMPLATE 'year2006-2007';
But the new database conta
That's what she said.
Someone had to do it.
That's what she said, again.
Sorry.
-salman
-
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
so you don't have
to pipe multiple times (eg: grep -i -e bleh -e bleh2 -e bleh3 -ve backup)
2) wouldn't find be easier to use? find . -maxdepth 1 -type -f -print
-salman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscrip
A couple of questions about these files:
1) When are these generated? Is this once an archive is generated, or
once the full archive_command has run?
2) Is there any harm in removing these files by appending an rm command
at the end of archive_command?
-salman
--
Sent via pgsql-admin
Please chek again and inform me.thanx for the information.
On 12/28/09, Shruthi A wrote:
> On 12/28/09, Premila Devi wrote:
>>
>> select sum(alq.quantity + alq.locked), category.id, alq.assetStatus.name
>>
>> from AssetLocationQuantity alq inner join alq.asset asset inner join
> asset.assetModel
