Re: [GENERAL] Looking for a script that performs full online backup of postgres in archive mode

2009-11-09 Thread Mark Styles
On Mon, Nov 09, 2009 at 09:15:03AM -0500, Chris Barnes wrote: > Would anyone in the postgres community have a shell script that > performs a full online backup of postgres? Here's roughly what we do: REMOTE="foo" DATA="/srv/pgdata" WAL="/var/lib/pgsql/wal-archive" PSQL="/usr/bin/psql" RSYNC="/us

Re: [GENERAL] What kind of JOIN, if any?

2009-09-17 Thread Mark Styles
On Thu, Sep 17, 2009 at 10:29:11AM -0400, Paul M Foster wrote: > I can't find a way to do this purely with SQL. Any help would be > appreciated. > > Table 1: urls > > id | url > -- > 1 | alfa > 2 | bravo > 3 | charlie > 4 | delta > > Table 2: access > > userid | url_id > ---

Re: [GENERAL] pgsql announce now on twitter

2009-03-05 Thread Mark Styles
On Thu, Mar 05, 2009 at 09:44:58AM -0500, Douglas J Hunley wrote: > On Wednesday 04 March 2009 15:39:36 Mark Styles wrote: > > On Tue, Mar 03, 2009 at 09:38:39PM -0500, Douglas J Hunley wrote: > > > I really wanted to let everyone know that I've created @PGSQL_Announce on &g

Re: [GENERAL] pgsql announce now on twitter

2009-03-04 Thread Mark Styles
On Tue, Mar 03, 2009 at 09:38:39PM -0500, Douglas J Hunley wrote: > I really wanted to let everyone know that I've created @PGSQL_Announce on > Twitter and setup a cron job to parse the feed and post it to Twitter. > It's been working for a little while now and I think it's stable enough to > an

Re: [GENERAL] Changing owner of pg_toast tables

2009-01-29 Thread Mark Styles
On Thu, Jan 29, 2009 at 02:11:37PM -0500, Tom Lane wrote: > Mark Styles writes: > > Thanks, I managed to clear out the offending dependencies. relowner was > > actually set correctly, but the pg_shdepend records were wrong. > > Hmm ... what actually was in the pg_shdepen

Re: [GENERAL] Changing owner of pg_toast tables

2009-01-29 Thread Mark Styles
On Thu, Jan 29, 2009 at 12:29:07PM -0500, Tom Lane wrote: > Mark Styles writes: > > On Thu, Jan 29, 2009 at 10:46:08AM -0500, Tom Lane wrote: > >> I guess the interesting question to me is what happened to the tables > >> those toast tables are/were attached to

Re: [GENERAL] Changing owner of pg_toast tables

2009-01-29 Thread Mark Styles
On Thu, Jan 29, 2009 at 10:46:08AM -0500, Tom Lane wrote: > Mark Styles writes: > > I'm trying to drop a role that is no longer being used. However the role > > has 4 dependencies which are all pg_toast tables. How can I change the > > owner of those pg_toast tables so I

[GENERAL] Changing owner of pg_toast tables

2009-01-29 Thread Mark Styles
Hi, I'm trying to drop a role that is no longer being used. However the role has 4 dependencies which are all pg_toast tables. How can I change the owner of those pg_toast tables so I can drop the role? -- Mark http://www.lambic.co.uk signature.asc Description: Digital signature

Re: [GENERAL] Select CASE when null ?

2009-01-14 Thread Mark Styles
On Wed, Jan 14, 2009 at 05:35:55PM -0300, Camilo Sperberg wrote: > SELECT > CASE mid WHEN NULL THEN CAST(0 AS integer) >ELSE mid > END AS mid, > CASE id_group WHEN NULL THEN CAST(0 AS integer) > ELSE id_group > END AS id_group > FROM users > WHERE username = 'tes

Re: [GENERAL] Select CASE when null ?

2009-01-14 Thread Mark Styles
On Wed, Jan 14, 2009 at 05:35:55PM -0300, Camilo Sperberg wrote: > SELECT > CASE mid WHEN NULL THEN CAST(0 AS integer) >ELSE mid > END AS mid, > CASE id_group WHEN NULL THEN CAST(0 AS integer) > ELSE id_group > END AS id_group > FROM users > WHERE username = 'tes