Re: [ADMIN] When does VACUUM FULL not clean out all deleted data?

2008-01-05 Thread James Cloos
> "Scott" == Scott Marlowe <[EMAIL PROTECTED]> writes: Scott> Note that routine vacuum FULL is not a good idea actually. Scott> vacuum full is something you run when things have gone wrong Scott> (i.e. not enough regular vacuuming) and it is usually best Scott> followed by reindexing all your

Re: [ADMIN] When does VACUUM FULL not clean out all deleted data?

2008-01-05 Thread James Cloos
> "Joshua" == Joshua D Drake <[EMAIL PROTECTED]> writes: Joshua> Autovacuum by default won't do enough work for many production Joshua> databases. You still have to configure it. OK. Thanks. Good to know. -JimC -- James Cloos <[EMAIL PROTECTED]> OpenPGP: 1024D/ED7DAEA6 --

Re: [ADMIN] Need source for Solaris 9

2008-01-05 Thread ameya agnihotri
You can find binary on http://www.sunfreeware.com/indexsparc9.html also. On Jan 5, 2008 8:38 PM, <[EMAIL PROTECTED]> wrote: > > > > > On Fri, 4 Jan 2008, Suresh Gupta VG wrote: > > > Hi Team, > > > > > > > > I am using 7.4.2 version of Postgresql on "Solaris 9 9/04 s9s_u7wos_09 > > SPARC". I need

Re: [ADMIN] Need source for Solaris 9

2008-01-05 Thread rloefgren
On Fri, 4 Jan 2008, Suresh Gupta VG 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/). I could see only for

Re: [ADMIN] invalid byte sequence for encoding "UNICODE":0xa1

2008-01-05 Thread Popovici Alexandru
Thank you for your answer. I tryed to restore the dump file ( some data was deleted an need it to be restored ) on the same server on which was made (windows 2003 ), using the same software ( pgAmin ) used at backup. I have not change any settings for PostgreSQL server or pgAdmin. The dat