Re: [HACKERS] Which table stored in which file in PGDATA/base/[db-oid]

2013-06-04 Thread David Kerr
- On Sat, Jun 1, 2013 at 3:57 PM, Andres Freund wrote: - - > On 2013-06-01 13:04:55 +0200, Martijn van Oosterhout wrote: - > To get the actual relfilenode you actually need to do something like: - > SELECT relname, pg_relation_filenode(pg_class.oid) FROM pg_class; - - Dear Andres - - You are rig

Re: [HACKERS] Use of rsync for data directory copying

2012-07-09 Thread David Kerr
On Jul 9, 2012, at 7:48 PM, Bruce Momjian wrote: > Rsync is popular with Postgres users, but I don't understand how they > are using the default check mode (file size, modification time) to > synchronize shut-down data directories? It seems they would have to use > --checksum because it is too e

Re: [HACKERS] empty backup_label

2012-06-26 Thread David Kerr
On Tue, Jun 26, 2012 at 05:33:42PM +0200, Magnus Hagander wrote: - On Tue, Jun 26, 2012 at 5:24 PM, Robert Haas wrote: - > On Sun, Jun 24, 2012 at 5:33 PM, David Kerr wrote: - >> Howdy, - >> - >> We're using NetApp's flexclone's whenever we need to move our

[HACKERS] empty backup_label

2012-06-24 Thread David Kerr
Howdy, We're using NetApp's flexclone's whenever we need to move our DB between machines. One specific case where we do that is when we're creating a new streaming replication target. The basic steps we're using are: pg_start_backup(); pg_stop_backup(); The problem i'm seeing is that periodi

Re: [HACKERS] foreign key locks, 2nd attempt

2011-11-11 Thread David Kerr
On Thu, Nov 10, 2011 at 03:17:59PM -0500, Christopher Browne wrote: - On Sun, Nov 6, 2011 at 2:28 AM, Jeroen Vermeulen wrote: - > On 2011-11-04 01:12, Alvaro Herrera wrote: - > - >> I would like some opinions on the ideas on this patch, and on the patch - >> itself.  If someone wants more discussi

Re: [HACKERS] default_tablespace

2011-02-17 Thread David Kerr
On Thu, Feb 17, 2011 at 08:55:55PM +0100, Florian Pflug wrote: - On Feb17, 2011, at 18:32 , David Kerr wrote: - > On Wed, Feb 16, 2011 at 03:59:13PM -0800, carl clemens wrote: - > - After reviewing docs and searching web - > - cannot find out how to determine the default tablespace - >

Re: [HACKERS] default_tablespace

2011-02-17 Thread David Kerr
On Wed, Feb 16, 2011 at 03:59:13PM -0800, carl clemens wrote: - Hi Hackers, - - After reviewing docs and searching web - cannot find out how to determine the default tablespace - of a user? - - Like: - - select spcname from blab where roloid = ; - - Is this possible? - - Thank you for your