Re: [ADMIN] Slony NG

2004-07-15 Thread Marc G. Fournier
On Thu, 15 Jul 2004, Christopher Browne wrote: Oops! [EMAIL PROTECTED] (Gaetano Mendola) was seen spray-painting on a wall: | You are aware that there is a slony mailing list at | http://gborg.postgresql.org/mailman/listinfo/slony1-general right? Does | that not serve your purposes? I knew it, some

Re: [ADMIN] Connection pooling/sharing software help

2004-07-15 Thread Kris Kiger
This looks exactly like what we want. Currently we are using JDBC to maintain persistent connections. The advantage to this is that you can use the JDBC driver written specifically for your version of Postgres (level 1 or level 4, I forget which is the closest). Do you have any idea how clos

Re: [ADMIN] Slony NG

2004-07-15 Thread Christopher Browne
Oops! [EMAIL PROTECTED] (Gaetano Mendola) was seen spray-painting on a wall: > | You are aware that there is a slony mailing list at > | http://gborg.postgresql.org/mailman/listinfo/slony1-general right? Does > | that not serve your purposes? > > I knew it, some times I'm in IRC too, but I feel bet

[ADMIN] Connection pooling/sharing software help

2004-07-15 Thread Kris Kiger
Here is the scenario I am running into: I have a cluster of databases. I also have another cluster of machines that will have to talk with some of the database machines. Rather than set up a connection to each databases from each of the 'talking' machines, is it possible to share a single co

Re: [ADMIN] Slony NG

2004-07-15 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Robert Treat wrote: | On Tue, 2004-07-13 at 19:56, Gaetano Mendola wrote: | |>-BEGIN PGP SIGNED MESSAGE- |>Hash: SHA1 |> |>Bruno Wolff III wrote: |> |>| On Tue, Jul 13, 2004 at 15:32:49 +0200, |>| Gaetano Mendola <[EMAIL PROTECTED]> wrote: |>|

Re: [ADMIN] Slony NG

2004-07-15 Thread Robert Treat
On Tue, 2004-07-13 at 19:56, Gaetano Mendola wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Bruno Wolff III wrote: > > | On Tue, Jul 13, 2004 at 15:32:49 +0200, > | Gaetano Mendola <[EMAIL PROTECTED]> wrote: > | > |>-BEGIN PGP SIGNED MESSAGE- > |>Hash: SHA1 > |> > |>Bruno

[ADMIN] recover deletede tuples

2004-07-15 Thread Lending, Rune
Title: Melding I have deleted some important tuples, but have not run vacuum yet. I am looking at the oid file in the base structure, and I can see the tuples are in this file. I used pgfsck and worked just fine on small tables, but it dies when I am running it on a large table.  The datas

Re: [ADMIN] [HACKERS] Point in Time Recovery

2004-07-15 Thread Simon Riggs
On Thu, 2004-07-15 at 02:43, Mark Kirkwood wrote: > I noticed that compiling with 5_1 patch applied fails due to > XLOG_archive_dir being removed from xlog.c , but > src/backend/commands/tablecmds.c still uses it. > > I did the following to tablecmds.c : > > 5408c5408 > < extern c