Re: [ADMIN] archive_command and streaming replication

2012-03-12 Thread MirrorX
i dont quite understand the question. could you pls clarify a little? you want to save the pg_xlog-files from where? the master of the slave? the tool you are looking for, if it exists, should do what? thx On Sun, Mar 11, 2012 at 11:05 PM, Martin von Oertzen [via PostgreSQL] < ml-node+s1045698n5

Re: [ADMIN] triggers are not shared between parent and child tables?

2012-03-12 Thread Rural Hunter
hmmif you ask me, I would like to suggest add this part in the fisrt step(create the master table) of 5.9.2 of this doc: http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html The doc mentions here that there is no point to define indexes/constraints on parent table. But it didn't m

Re: [ADMIN] triggers are not shared between parent and child tables?

2012-03-12 Thread Kevin Grittner
Rural Hunter wrote: > is it worth mentioning in the doc? Do you have a suggestion for what language you would have found helpful, or which section(s) of the docs should be modified? -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscriptio

Re: [ADMIN] triggers are not shared between parent and child tables?

2012-03-12 Thread Rural Hunter
yes, I understand that. but is it worth mentioning in the doc? 于2012年3月12日 22:11:16,Kevin Grittner写到: Rural Hunter wrote: "triggers are not shared between parent and child tables". is it true? Yes. You can use the same trigger *function* for more than one trigger though. -Kevin -- Se

Re: [ADMIN] How to back up selected rows using

2012-03-12 Thread Kevin Grittner
Piyush Lenka wrote: > How can i backup only 5 records from that table using pg_dump or psql or > both. In psql: \copy ( select * from that_table where ... ) to 'filename' http://www.postgresql.org/docs/9.1/interactive/app-psql.html Search the page for \copy -Kevin -- Sent via pgsql-a

[ADMIN] How to back up selected rows using

2012-03-12 Thread Piyush Lenka
Hi, I have one table in my database. The table contains 10 records(rows) . I want only 5 records(rows) to be backed up. How can i backup only 5 records from that table using pg_dump or psql or both. Please Help. Regards Piyush

Re: [ADMIN] triggers are not shared between parent and child tables?

2012-03-12 Thread Kevin Grittner
Rural Hunter wrote: > "triggers are not shared between parent and child tables". is it > true? Yes. You can use the same trigger *function* for more than one trigger though. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: ht