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/d

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 comme

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 > . >

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 seque

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 Arc

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 C:\PostgreSQL\8.0\bi

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 c

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

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 some

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

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 vacu

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