[ADMIN] Privileges on sequences

Hello, We are using PGSQL 8.3.4 I have problem to grant privileges to a sequence. If I grant all to the user I can do something like : SELECT nextval('reflex_cited_reports_id'); SELECT nextval('reflex_cited_reports_id'); nextval -- 40442939 (1 row) BUT if I grant the same priv to the

[ADMIN] speeding up backup with -Fc -Z ?

Hello, During our backup, we are using pg_dump (sql format if no LO) and then gzip to compress the sql file. I read that the "custom" format can also compress ( -Z option) the dump. Does someone use the latest to dump/compress backups ? Could it be a good way to speed up the backup ? Regards

[ADMIN] corruption since 7.4.13 update ?

Hello, I'e got a very strange (scary) problem. Look at that : itu_test-# \d ERROR: cache lookup failed for relation 1024 itu_test=# \q [EMAIL PROTECTED] ~]$ psql -h pisa itu_test itu_test=# \d ERROR: cache lookup failed for relation 1024 itu_test=# select * from zones; zone_id | code | regio

Re: [ADMIN] advice on PGSQL cluster (active/passive)

Thanks for the response, What do you mean by " You need to configure the cluster.conf so that it uses any fence device otherwise your nodes may fail randomly." FYI : I'll use my APC symetra as my fencing device thank you ! Devrim GUNDUZ wrote: > Hi, > > On Tue, 2006-

[ADMIN] advice on PGSQL cluster (active/passive)

Hello, Next month I will receive my SAN and a new server. Using Redhat Cluster Suite + GFS, I'd like to create a PGSQL active/passive cluster. Do you have some advice about this setup or advice for PGSQL Clustering ? For now, we are using 7.4.x but we will migrate to 8.1.x My passive server wi

[ADMIN] backup restore of DB + LO

Hello everybody, I'm trying backup restore of DB with LO. I backuped using as superuser : pg_dump -d -o -F t -b -u database --file=database.tar Because the superuser is not the DB owner, I create the DB on another server (same os ans same version of PGSQL which is 7.4.8 ) : CREATE DATABASE

Re: [ADMIN] install new version of Redhat without deleting

I'm usung postgresql.org RPMS so the RPMS will be exactly the same. Of course I'll do my pgdump before my try. Thank to you all ! Scott Marlowe wrote: On Wed, 2005-10-19 at 10:47, FM wrote: Hello erverybody, I need to install a new version of Redhat on my server. On the distro,

[ADMIN] install new version of Redhat without deleting /var/lib/pgsql ? Is it enough ?

Hello erverybody, I need to install a new version of Redhat on my server. On the distro, pgsql data are in : /var/lib/pgsql (which is mounted on its own partition). Can I "just" install the new version of Redhat, reinstall the same version of Postgresql (7.4.8) ? I'll do a pgdump all just in ca

[ADMIN] problem during amrestore

hello, I'm trying to recover files from a backup but I received this : amrestore: could not fsf /dev/nst0: Input/output error my cmd : amrestore /dev/nst0 ravenna /var/lib/pgsql/backups I tried on 2 tapes , but I always have this error :( ---(end of broadcast)

Re: [ADMIN] some databases have not been vacuumed ...

I vacumm all DB ...except... postgres ones. I"ll do a vacuum -all tonight What is you vacuum strategy ? vacuum everyday and vacuum full analyse ervery week ? thanks ! Joshua D. Drake wrote: FM wrote: Hello after a vacuum full analyse I received this : WARNING: some databases hav

[ADMIN] some databases have not been vacuumed ...

Hello after a vacuum full analyse I received this : WARNING: some databases have not been vacuumed in 1805294030 transactions HINT: Better vacuum them within 342189617 transactions, or you may have a wraparound failure. I read that it's because i do not vacuum DB very often. Now I vacuum eve

[ADMIN] PGSQL 7.4.8 : idle in transaction problem

Hello, We are using JBOSS and postgresql on 1 database (DB1). From time to time the JBOSS process . What is strange is that users on all DB (not only DB1) are affected by the JBOSS . I understand that it locked DB1 but why it also locked users on others DB ? Thanks !

[ADMIN] backing up without lock ?

Hello, Is it possible to backup postgresql databases without locking tables. Thanks ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[ADMIN] pgsql 7.4.8 : vacuum and blobs ?

Hello, I had a large DB (db1) 12 GB using Blobs. To remvoe old large objects I connected to db1 and did a . But the database size is still 12GB. How can I clan lod blobs from database ? Thanks ---(end of broadcast)--- TIP 5: Have you checked ou

[ADMIN] tuning shared buffers and check biggest row size

Hello, I read some articles about PGSQL tuning (7.4.x). We have a dedicated DB server with 6 GB of RAM. So I'm trying to determine the the size of my shared buffers. Ho wcan I find the biggest size of a database ? Thanks, ---(end of broadcast)--- TI

[ADMIN] pg_hba and *

Hello, We have kerberos auth for all humain users, but I still need md5 auth for scripts users. All my scripts user name start with soft_ Can I add soft_* in the pg_hba ? thanks ---(end of broadcast)--- TIP 9: the planner will ignore your desire to

[ADMIN] postgresql 7.4.1 SRPM

I'm using RPM from postgresql site (v 7.4.1). I need to add krb5 auth so I need to recompile SRPMS. I cannot find it in the source tree. Is there a place where we can find the SRPM ? thanks, ---(end of broadcast)--- TIP 9: the planner will ignore yo