Re: [ADMIN] Question on moving data to new partitions

2010-01-13 Thread Radhika Sambamurti
Scott Marlowe wrote: On Wed, Jan 13, 2010 at 6:11 PM, Benjamin Krajmalnik k...@illumen.com wrote: Yes, I will be using table inheritance and inheriting the current table where the data resides. I was wondering if it would be kosher to perform the insert on itself, but I guess since the

[ADMIN] Linking libraries problem after Postgres-8.2.0 install

2007-06-29 Thread Radhika Sambamurti
Hi, I was running postgres-7.4.2 and upgraded to 8.2.0 Postgres-8.2.0 built successfully. But when I do an ldd on postgres I see that it is linking to the wrong openssl and crypto libraries. engpc17 bin]# ldd postgres libssl.so.4 = /lib/libssl.so.4 (0x0091e000) libcrypto.so.4 =

[ADMIN] Postgresql Upgrade 7.4 to 8.2

2007-01-24 Thread Radhika Sambamurti
Hi, I am soon going to be testing postgresql upgrades from our ancient 7.4 version to the latest 8.2. Part of the reason (apart from the obvious) is that I want to implement WAL logging for backup and recovery. Some general questions I have are: 1. How is the backup and recovery using WAL