[pgadmin-support] PG Admin on the command line = pg_dump

Hi, I would like to automate the generation of a backup script of a schema (which I used to perform with PG Admin backup command). I looked into pg_dump command: it does the job BUT not correctly for me as it does not create SERIAL column but INTEGER and then it creates SEQUENCES (I have script

Re: [pgadmin-support] [ADMIN] DB problem

Vinayak, Please don't post twice to two different lists (four of the same posts to both pgsql-admin and pgadmin-support.) This clearly isn't a problem with PG Admin - so don't clutter that list up, and don't multiple-post - it won't change anything posting twice, and if anything you'll only en

Re: [pgadmin-support] DB problem

Vinayakr, We are using PostgreSQL 7.3 version, installed in linux system. Only DB is getting shut down 3-4 times a day. From my application end I get "Sorry too many clients" error. Maybe you should rise the maximum connections? log_timestamp= true log_directory=pg_log log_filename=%Y-%m-%d_

[pgadmin-support] DB problem

Hi, We are using PostgreSQL 7.3 version, installed in linux system. Only DB is getting shut down 3-4 times a day. From my application end I get "Sorry too many clients" error. Refering the FAQ I maximized the DB session limit to 200.  I think the logs are not enabled in my DB. So I set the followin

Re: [pgadmin-support] DB problem

2006/12/26, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: Hi, We are using PostgreSQL 7.3 version, installed in linux system. Only DB is getting shut down 3-4 times a day. From my application end I get "Sorry too many clients" error. Refering the FAQ I maximized the DB session limit to 200. I thin