- 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
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
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
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
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
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
- >
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