Re: [ADMIN] Syncing DBs prior to RServ replication

2003-06-10 Thread Mendola Gaetano
"Michael A Nachbaur" <[EMAIL PROTECTED]> wrote: > I'm looking at syncronizing two database servers with RServ (production / "hot > standby"), and I'm trying to figure out a way to get the initial database on > the slave server syncronized with the master. > > Normally, I would 1) turn off all clien

Re: [ADMIN] Problem with tcp/ip connection, postgresql.conf

2003-06-10 Thread Robert Treat
On Sun, 2003-06-08 at 11:50, Tom Lane wrote: > > While experimenting with this, I noted that the postmaster will not > complain if postgresql.conf is not found --- though it will complain if > it finds the file but can't read it (eg permission failures). It seems > to me this is a bug, or at any

Re: [ADMIN] Help! Error when calling a function

2003-06-10 Thread Joe Conway
Ben Schneider wrote: fine. The only change I made to the DB was to drop the feedback_notes table and recreate it with an additional column (New column = 'status'). The select was working before I made this change and now it doesn't. I can't explain the exact cause in this case, because I don't see

[ADMIN] Ideas for Postgres book

2003-06-10 Thread Paul Weinstabl
Hi all, I hope this reaches the right people. I was asked by a german publisher, if I would be able to come up with a book about PostgreSQL server programming (topics mainly on PL/pgSQL). I have indeed been thinking about doing this, but so far have had no fixed idea or concept what such a boo

[ADMIN] table vs. view maximum columns

2003-06-10 Thread A.M.
I have 560 columns of NUMERIC(10,14). In order not to run up against max column constraints, I split the information into two tables. Does the column limit on tables imply the same limit for views or selects or could I potentially select a row across both tables and make a view that hides the s