Re: [GENERAL] unexplained autovacuum to prevent wraparound

Ah, now I see what you meant. Forgive me, I thought you were referring to the pg_autovacuum table in 8.3 where you have to specifiy something for each column, and -1 says use the default. It appears in 8.4.0 I have to explicitly set ALL (?) other storage parameters to -1 to get the default, other

[GENERAL] libpq: compatibility with server versions

Hi all, I am using libpq 8.2.4 (and my own wrapper around it) for a long time now. Due to some performance penalties I would like to upgrade to 8.4.x libpq. Is it o.k. if I upgraded my libpq to the newer 8.4 libraries but would still connect to old 8.2 servers? Are there any compatibility issues

Re: [GENERAL] ERROR: Package compat-postgresql-libs-4-1PGDG.rhel4.i386.rpm is not signed

Padmanabhan G wrote: Hi, I have an error while installing Postsgresql 8.3 in Cent OS 4. I did the following... # rpm -ivh pgdg-centos-8.3-6.noarch.rpm # #vi /etc/yum.repos.d/CentOS-Base.repo Add "exclude=postgresql*" to both section [base] and [update]. #yum install postgresql-server Depen

Re: [GENERAL] restoring a database to its initial state

Pavel Stehule writes: > 2010/3/13 Manlio Perillo : >> Usually when I need to restore a database to its initial state, what I >> do is to simply drop it, and then re-create it. >> However on a shared hosting this is not possible. > Usually people use a install and a uninstall scripts. First create

Re: [GENERAL] restoring a database to its initial state

Hyho! On Saturday 13 March 2010 13.48:14 Manlio Perillo wrote: > Usually when I need to restore a database to its initial state, what I > do is to simply drop it, and then re-create it. > > However on a shared hosting this is not possible. Create a schema, modify your default search path so tha

Re: [GENERAL] restoring a database to its initial state

Hello 2010/3/13 Manlio Perillo : > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi. > > Usually when I need to restore a database to its initial state, what I > do is to simply drop it, and then re-create it. > > However on a shared hosting this is not possible. > > By initial state I mean:

[GENERAL] restoring a database to its initial state

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi. Usually when I need to restore a database to its initial state, what I do is to simply drop it, and then re-create it. However on a shared hosting this is not possible. By initial state I mean: The content of template1 database or The databa

[GENERAL] Hints for postgresql package recompilation (FIXED)

FIXED!! compilation needs a non root user (initdb complains about root during tests )... regards, Angel # Hi, We are trying to deploy an OpenBravo installation on OpenSuSE 11.2 X64 and are using Postgresql 8.4.2-1.1.1 as the data backend, but OpenS

[GENERAL] explicit cast for null::bigint

I've found this a bit strange: insert into catalog_related (itemid, related_itemid, rank) select distinct itemid, null::bigint, 0::float4 from catalog_categoryitem where catid is null or catid<>0 and itemid not in (select itemid from

Re: [GENERAL] hardware for a server

On Sat, Mar 13, 2010 at 1:34 AM, A B wrote: > Hello. > > It's time to get new hardware for a server that will run both > PostgreSQL and Apache. > The workload will be similar to that of  your standard "PHP forum" > (most selects and logging of stuff that has been read) > > The modell I'm looking a

[GENERAL] hardware for a server

Hello. It's time to get new hardware for a server that will run both PostgreSQL and Apache. The workload will be similar to that of your standard "PHP forum" (most selects and logging of stuff that has been read) The modell I'm looking at right now is 2x Xeon E5520 2,26 GHz 8 MB (8 cores in tot