Re: [ADMIN] Need source for Solaris 9

2008-01-04 Thread Usama Dar
On Jan 4, 2008 4:24 PM, Suresh Gupta VG [EMAIL PROTECTED] wrote: Hi Team, I am using 7.4.2 version of Postgresql on *Solaris 9 9/04 s9s_u7wos_09 SPARC*. I need to upgrade to pgsql-8.2.5 version. I could not get the source for the solaris-9 on the site(http://www.postgresql.org/download/).

Re: [ADMIN] Need some help in psql Configuration

2008-01-01 Thread Usama Dar
On Dec 31, 2007 11:21 AM, Suresh Gupta VG [EMAIL PROTECTED] wrote: Hi Team, I am using Postgresql 7.4 version. We are willing to update the version to the latest. Can you pls give some guidelines and provide the link to the software to download. Is it free downloadable or commercial, pls

Re: [ADMIN] separating PG binaries into a ro mounted partition

2007-12-30 Thread Usama Dar
So, what are the installation options to acheive what I specified in the OP? Did you go through this? http://www.postgresql.org/docs/8.2/static/install-procedure.html -- Usama Munir Dar http://www.linkedin.com/in/usamadar Consultant Architect Cell:+92 321 5020666 Skype: usamadar

Re: [ADMIN] Fresh copy of a PG DB ?

2007-12-28 Thread Usama Dar
On Dec 28, 2007 5:58 PM, Cédric Villemain [EMAIL PROTECTED] wrote: Pascal Heraud a écrit : Is there any specific issues with gentoo ? no, there is nothing specific to Gentoo, but the power of Gentoo is the tweaking, not the stable production server you can expect to admin quietly . search

Re: [ADMIN] pg_hba.conf is driving me nuts

2007-12-16 Thread Usama Dar
Now, I have set up all the appropriate port forwarding, made sure that there are no problems with firewalls on the server. Just to make sure there really is no issue with firewall did you try something like telnet on postgres host and port , like telnet buggy.pg.net5432, you should get

Re: [ADMIN] reading pg_stat_activity view

2007-12-16 Thread Usama Dar
There wouldn't be any way to just log it and still keep the query alive, would there? I think it will be a useful feature to add to postgres, for the benefit of DBAs, the ability to log slow queries, the queries which take more than x amount of time, maybe in a separate slow query log. i am

Re: [ADMIN] Canceling process from pgAdmin III

2007-12-16 Thread Usama Dar
On Dec 14, 2007 2:15 AM, Sebastián Baioni [EMAIL PROTECTED] wrote: Hi, In Earlier versions of PostgreSQL (installed in FreeBSD) we could cancel process from Server Status of pgAdmin III (in MS Windows). Now we have PG 8.2 and we can't do it anymore. ¿What must we change to be able to cancel

Re: [ADMIN] Postgres installation problem

2007-12-16 Thread Usama Dar
On Dec 7, 2007 10:39 AM, lattab kader [EMAIL PROTECTED] wrote: Hi all I have installed the postgresq 8.0 as a program in C:\PostgreSQL\8.0. I have also set the ENV varibale PGDATA as C:\PostgreSQL\8.0\share for the postgre.conf file. when I try to start it from

Re: [ADMIN] sequence owned by backwards compatability

2007-12-16 Thread Usama Dar
On Dec 12, 2007 1:59 PM, DBA [EMAIL PROTECTED] wrote: Hi Experts, I am very new to Postgres. Can any body tell me the steps how to install 8.2.5 on fedora core 6. Manual is your friend? thanks in advance. -- Usama Munir Dar http://linkedin.com/in/usamadar Consultant Architect

Re: [ADMIN] pg_restore error

2007-12-16 Thread Usama Dar
On Dec 13, 2007 10:06 PM, Kevin Kempter [EMAIL PROTECTED] wrote: Hi list; We're seeing this error whern trying to restore a pg_dump file: - pg_restore: ERROR: invalid byte sequence for

Re: [ADMIN] Enhancement request

2007-12-02 Thread Usama Dar
On Dec 2, 2007 6:31 AM, Alvaro Herrera [EMAIL PROTECTED] wrote: Joshua D. Drake escribió: On Fri, 30 Nov 2007 19:34:02 -0300 Alvaro Herrera [EMAIL PROTECTED] wrote: Joshua D. Drake escribió: The multi-worker autovacuum is a great new addition to help part of that problem

Re: [ADMIN] connection limit exceeded

2007-11-30 Thread Usama Dar
On Dec 1, 2007 1:34 AM, Tena Sakai [EMAIL PROTECTED] wrote: Hi Jonah, Many thanks! 2) how would I look at the open/used connections? select * from pg_stat_activity; This is a wonderful view! How would I properly terminate these (of course there are 99 of them!) these query process?

Re: [ADMIN] Enhancement request

2007-11-30 Thread Usama Dar
On Dec 1, 2007 12:46 AM, Campbell, Lance [EMAIL PROTECTED] wrote: Could you please add to your to do list a schema parameter for vacuum? Example: VACUUM SCHEMA xyz; PostgreSQL would get a list of all of the tables found in the schema. It would then loop through vacuuming each