[ADMIN] backup including symbolic links?

Hello, I have a 450gb production database, and was trying to create a development database using a bkp. I was following the instructions on postgres documentation, and came across the paragraph that says... " If you are using tablespaces that do not reside underneath this (data)

Re: [ADMIN] backup including symbolic links?

On Jan 25, 2008 1:55 PM, NUWAN LIYANAGE wrote: > Hello, > > I have a 450gb production database, and was trying to create a development > database using a bkp. > I was following the instructions on postgres documentation, and came across > the paragraph that says... > " If

Re: [ADMIN] backup including symbolic links?

Thank you very much Scott.. I'll keep you updated on my progress. Thanks again. Nuwan. Scott Marlowe <[EMAIL PROTECTED]> wrote: On Jan 26, 2008 3:06 PM, NUWAN LIYANAGE wrote: > Yes, I was thinking of doing a pg_dumpall, but my only worry was that the > singl file is going to b

[ADMIN] rename database

Hi, I am trying to rename my database; I used the following command, Alter database postgres rename to post_dev; but I get a error saying that the "current database may not be renamed" I look at the documentation, and it says that I need to connect to a different database in order d

Re: [ADMIN] rename database

Ok I think I got it. I just went ahead and updated the pg_database table and it works.. Nuwan Liyanage <[EMAIL PROTECTED]> wrote: Hi, I am trying to rename my database; I used the following command, Alter database postgres rename to post_dev; but I get a error saying th

[ADMIN] Delete from base table and not partitions

Question: I have a base table with several temporal partitions like this: base_table partition_1 partition_2 There are check rules on partitions, and trigger rules on the base table to ensure data loaded into base_table goes to a correct partition. I added part

Re: [ADMIN] Delete from base table and not partitions

Thank you very much, I was not aware of the 'ONLY' clause. Nuwan. Tom Lane <[EMAIL PROTECTED]> wrote: Nuwan Liyanage writes: > Now I added the trigger rule to base_table and the data for > partition_3 is going to the right place, but I am stuck with some da

[ADMIN] Delete from base table and not partitions

Question: I have a base table with several temporal partitions like this: base_table partition_1 partition_2 There are check rules on partitions, and trigger rules on the base table to ensure data loaded into base_table goes to a correct partition. I added partition_3 and create

[ADMIN] Delete from base table and not partitions

Question: I have a base table with several temporal partitions like this: base_table partition_1 partition_2 There are check rules on partitions, and trigger rules on the base table to ensure data loaded into base_table goes to a correct partition. I added partition_3 and create