[ADMIN] about the time of a process

2001-09-28 Thread Manuel Trujillo
Hi. Another question... How many take to time a backend process if it haven't gos "traffic" (or run any query), to dead?? Have postgresql a SET command for determinate this question? I will apologize about my bad english... sorry please. Thank's for all. -- Manuel Trujillo [EMAIL PR

[ADMIN] postmaster dies with ssl lib error

2001-09-28 Thread Randall Perry
Suddenly getting this error on start on a Solaris 8 system (after applying a bunch of patches) > /usr/local/pgsql/bin/postmaster -D /export/spare/home/postgres/data & ld.so.1: /usr/local/pgsql/bin/postmaster: fatal: libssl.so.0.9.6: open failed: No such file or directory [1] 1959 [1]Killed

[ADMIN] Reporting Tool?

2001-09-28 Thread Chris Ruprecht
Hi all,   so far, I had no need to print any reports out of my PostGreSQL database, I was able to do everything through the web. However, things change and now, I need to write an invoicing system. I have been using PL/PGSQL in the past, but it doesn't seem to have the ability to produce any

[ADMIN] moving database to production

2001-09-28 Thread Srinivasa Rao Chava
Hi, How to move the database from devleopment to production. For example, the database is already in production and some of the tables required modifications. First those modification were implemented in develoment. The modified tables need to be moved to production from development,not the comple

Re: [ADMIN] pg_dump fails

2001-09-28 Thread david
Answering my own question (With some advice from Tom Lane .. Cheers), I had 2 users with the same usesysid, and this broke the dump (The dump that came with pgsql 7.1). It was easy to fix, I just needed to change the usesysid in pg_shadow of the user that I didn't intend to have owndership of t