I implemented table partition recently and found that the tiggers on
parent table are not working any more, except the before insert trigger
which redirects data to children table. The after insert/update triggers
are not working now. I understand the after insert trigger may not
working since
On 03/06/2012 02:03 PM, Todd Hunt wrote:
Hi,
First let me state that I'm not a DBA, but a developer. I know enough
about databases to be dangerous, but not enough to make any money at
it. ;-)
We are using large objects with OIDs as part of our data model. One
of our processes is to backup th
On Τετ 07 Μαρ 2012 15:14:33 Lukasz Brodziak wrote:
> Hello,
>
> I have a question regarding pg_attribute. In which file it is stored
> because the relfilenode for it shows 0 and file 1249 isn't present in
> the folder.
in my system:
dynacom=# SELECT pg_relation_filepath('public.vessels'::regclas
PostgreSQL 9.1.2
to keep the cpu- and io-load low, we use
streaming replication with only one slave.
http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Streaming_Replication
the slave is not using the "archive_command"
while in recovering mode.
is there any tool to save the pg_xlog-files
Hi,
First let me state that I'm not a DBA, but a developer. I know enough about
databases to be dangerous, but not enough to make any money at it. ;-)
We are using large objects with OIDs as part of our data model. One of our
processes is to backup the database every night. Our DBAs told me
