Grokbase
Topics Posts Groups | in
x
[ help ]

Simon Riggs (s...@2ndquadrant.com)

Profile | Posts (681)

User Information

Display Name:Simon Riggs
Partial Email Address:s...@2ndquadrant.com
Posts:
681 total
124 in PostgreSQL - Admin
125 in PostgreSQL - Advocacy
1 in PostgreSQL - Announce
38 in PostgreSQL - Bugs
41 in PostgreSQL - Docs
127 in PostgreSQL - General
10 in PostgreSQL - JDBC
233 in PostgreSQL - Performance
1 in PostgreSQL - SQL

5 Most Recent

All Posts
1) Simon Riggs [ANNOUNCE] PG UK 2008: "PostgreSQL in the UK"
| +1 vote
The PostgreSQL UK team will be running a one-day conference in Birmingham, UK on Wednesday April...
PostgreSQL - Announce
[ Profile | Reply to group ] [ Flat  Thread  Threaded ]
The PostgreSQL UK team will be running a one-day conference in
Birmingham, UK on Wednesday April 2nd, 2008.

http://www.postgresql.org.uk/

The main theme of the day is "PostgreSQL in the UK" and we have a range
of talks focused around the work of UK-based developers, successful
UK-based projects and UK companies.

If you're using PostgreSQL in the UK then please come along and join in,
you'll find many interesting people there from across Great Britain.

PG UK 2008 is brought to you jointly by the UK Unix User Group (UKUUG)'s
PostgreSQL Special Interest Group (SIG) and the UK PostgreSQL User Group
(UKPUG).

PG UK 2008 is running in parallel with and at the same venue as UKUUG's
Conference known as Spring 2008. If you are a delegate to PG UK 2008 you
will be able to attend Spring 2008 talks on the same day also if you
wish.

Please visit this web site for further details and links that will allow
you to book your place http://www.postgresql.org.uk/

There is an early-bird rate until the end of this month, so book soon.

Look forward to seeing you all there,

--
  Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com


---------------------------(end of broadcast)---------------------------
-To unsubscribe from this list, send an email to:

pgsql-announce-unsubscribe@postgresql.org
2) Simon Riggs Re: [GENERAL] standby questions
| +1 vote
What sort of thing are you looking for? pg_standby accepts a trigger file as well as various types...
PostgreSQL - General
[ Profile | Reply to group ] [ Flat  Thread  Threaded ]
On Sat, 2008-02-09 at 07:49 -0500, Chander Ganesan wrote:

> Signalling components could be added to pg_standby at some point...

What sort of thing are you looking for?

pg_standby accepts a trigger file as well as various types of signal.

--
  Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
3) Simon Riggs Re: [GENERAL] [ADMIN] Backup
| +1 vote
I think we all understand and agree, I just start twitching when anyone talks about it being OK to...
PostgreSQL - General
[ Profile | Reply to group ] [ Flat  Thread  Threaded ]
On Thu, 2008-01-31 at 10:02 -0500, Chander Ganesan wrote:
> Magnus Hagander wrote:
> > On Thu, Jan 31, 2008 at 03:34:05PM +0100, Martijn van Oosterhout wrote:
> >   
> >> On Thu, Jan 31, 2008 at 01:28:48PM +0000, Simon Riggs wrote:
> >>     
> >>> That sentence has no place in any discussion about "backup" because the
> >>> risk is not just a few transactions, it is a corrupt and inconsistent
> >>> database from which both old and new data would be inaccessible.
> >>>       
> >> Hmm? I thought the whole point of a filesystem snapshot was that it's
> >> the same as if the system crashed. And I was fairly sure we could
> >> recover from that...
> >>     
> >
> > That was my assumption as well. *Assuming* that the filesystem snapshot is
> > consistent. There are a bunch of solutions that don't do consistent
> > snapshots between different partitions, so if your WAL or one tablespace is
> > on a different partition, you'll get corruption anyway... (seen this in
> > Big Commercial Database, so that's not a pg problem)
> >   
> Agreed. That's why I made it a point to mention that all of your
> tablespaces should be on the same file system... In hindsight, I should
> have also stated that your WAL logs should be on the same file system as
> well...

I think we all understand and agree, I just start twitching when anyone
talks about it being OK to lose transactions when backing up. You meant
the ones currently in progress, not the ones already committed and on
disk.

--
  Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
4) Simon Riggs Re: [GENERAL] [ADMIN] Backup
| +1 vote
Yes! ...I meant via the free press, not via the courts.
PostgreSQL - General
[ Profile | Reply to group ] [ Flat  Thread  Threaded ]
On Thu, 2008-01-31 at 12:09 -0300, Alvaro Herrera wrote:
> > Simon Riggs wrote:
>
> >> As far as I am concerned, if any Postgres user loses data then we're all
> >> responsible.
>
> Remember, our license says this software is given without any warranty
> whatsoever, implicit or explicit, written or implied, given or sold,
> alive or deceased.

Yes! ...I meant via the free press, not via the courts.

--
  Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/
5) Simon Riggs Re: [GENERAL] [ADMIN] Backup
| +1 vote
That sentence has no place in any discussion about "backup" because the risk is not just a few...
PostgreSQL - General
[ Profile | Reply to group ] [ Flat  Thread  Threaded ]
On Thu, 2008-01-31 at 07:21 -0500, Chander Ganesan wrote:
> If you don't mind if you lose some transactions

That sentence has no place in any discussion about "backup" because the
risk is not just a few transactions, it is a corrupt and inconsistent
database from which both old and new data would be inaccessible.

As far as I am concerned, if any Postgres user loses data then we're all
responsible.

--
  Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

spacer
Profile | Posts (681)
Home > People > Simon Riggs