[ADMIN] Database performance problems

x27;t have slow query check enabled, will do after Christmas, but how can I use it to show things are not good? If anyone could help me it would be very much appreciated. If you need more info or details, I am very happy to give more. Thank you very much Best regards Renato Oliveira Renato Oli

Re: [ADMIN] How can i change the Postgres Database password?

Here is the command: ALTER USER WITH PASSWORD 'yournewpassword'; That Renato Oliveira e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 www.grant.co.uk<http://www.grant.co.uk/> Grant Instruments (Cambridge) Ltd Company registered in Engla

[ADMIN] PITR online backups Setup

Dear all, I am trying to setup PITR for online backup and also to create a more robust setup, in case our primary Postgres dies. I am testing this setup on Centos 5.4, Postgres version: 8.1.18 (not sure why Centos has this old version by default). I have enabled PITR, with the following comman

Re: [ADMIN] PITR online backups Setup

Renato Renato Oliveira e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 www.grant.co.uk<http://www.grant.co.uk/> Grant Instruments (Cambridge) Ltd Company registered in England, registration number 658133 Registered office address: 29 Station Road, Sh

[ADMIN] PostgreSQL backup idea

d the problems I am facing currently. Thank you very much. Really appreciate any help and input Best regards Renato Renato Oliveira e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/ Grant Instruments (Cambridge) Ltd Company register

Re: [ADMIN] URGENT :: FATAL: could not create lock file "postmaster.pid": Permission denied

I would check where postmaster is trying to create the pid and check if postgres has permission to write to the folder. Then Maybe change the location for pid creation. Check also postgreslog and see if you can spot the error. R Renato Oliveira Systems Administrator e-mail: renato.olive

Re: [ADMIN] URGENT :: FATAL: could not create lock file "postmaster.pid": Permission denied

How are you trying to start the postgres service? Which user are you trying to start it with? R Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 www.grant.co.uk<http://www.grant.co.uk/> Grant Instruments (Cambridg

Re: [ADMIN] URGENT :: FATAL: could not create lock file "postmaster.pid": Permission denied

Not a problem. We all need help from time to time. Maybe some time you will be able to help me as well. Nice meeting you too. Have a great day. R Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 www.grant.co.uk<h

Re: [ADMIN] CentOS & PostgreSQL help re: TIME_WAIT

Do you have an F5 load balancer in front of these web servers? Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/ Grant Instruments (Cambridge) Ltd Company registered in England, registration

Re: [ADMIN] Pg_ctl with postmaster -i option

If I understood correctly what you want is to allow remote users or clients to connect to your postgresql server I believe this is controlled by "pg_hba.conf" Add a line similar to: hostall all 192.168.10.0/24 trust Renato Renato Oliveira Systems Admin

[ADMIN] PITR clarification to certain points

ry.conf? I thought it would be a continuous process? I mean I thought the WARM server would be there reading the logs until I tell it otherwise. Guys I thank all of you in advance for this. If someone could clarify a bit to me it would be very much appreciated. Thank you very much Best regards

Re: [ADMIN] PITR clarification to certain points

? This is what I have done! I have not seen any mention of this in any documentation so far. Is that correct? Thank you Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/ Grant Instruments

[ADMIN] PG_DUMP backup

about PITR but I can't implement it yet as I am still figuring out certain things with the restore process. I would really appreciate helps, please? Thank you very much in advance Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 26081

Re: [ADMIN] PG_DUMP backup

Josh, That is great thank you very much I really appreciate your reply Thank you Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/ Grant Instruments (Cambridge) Ltd Company registered in

Re: [ADMIN] PG_DUMP backup

pitr? Combination? I have an idea of what hardware I should have to run a 176GB database, but what sort of configuration are you guys running? Thank you very much Best regards Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44

Re: [ADMIN] PG_DUMP backup

as and any help. Really appreciated. Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/ Grant Instruments (Cambridge) Ltd Company registered in England, registration number 658133 Registe

[ADMIN] PITR load on servers - increased 20%

your experiences, please? Thank you very much Best regards Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/ Grant Instruments (Cambridge) Ltd Company registered in England, registration

Re: [ADMIN] Migration of PGDATA

Only out of curiosity, is your current server 32 bit or 64? Are you migrating 32 to 32 or 64 to 64? Thank you Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/ Grant Instruments (Cambridge

[ADMIN] Migrate postgres to newer hardware

be similar. This similarity needs to be even in architecture? I think I read something which says "Yes". If we cannot use PITR what would be the best approach, we can't have down time I am afraid. Any ideas or suggestions would be very welcome. Thank you very much Best regards R

Re: [ADMIN] Migrate postgres to newer hardware

. The DB grows around 1GB every 2 days. Do you still think slony would work? Thank you very much Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 www.grant.co.uk<http://www.grant.co.uk/> Grant Instr

Re: [ADMIN] Migrate postgres to newer hardware

Hi Brad, Thank you for your reply, really appreciated. Do you know how much load slony gives to your servers? Thank you again Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/ Grant

Re: [ADMIN] Migrate postgres to newer hardware

That is very true and well pointed out. Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/ Grant Instruments (Cambridge) Ltd Company registered in England, registration number 658133 Registered

Re: [ADMIN] Migrate postgres to newer hardware

If I use postgres 32 bit will it benefit from the extra memory on the system? I don't think it will. Thank you very much Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/

Re: [ADMIN] Migrate postgres to newer hardware

Are there any commercial solutions out there for migrating large DBs? Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/ Grant Instruments (Cambridge) Ltd Company registered in England

Re: [ADMIN] Migrate postgres to newer hardware

Tino, I did try mirroring the disk using 'dd' command and it took me a long time. At the end postgres did not start up. I am sure I could probably get postgres working, but the db integrity not sure about that. Thank you very much for the input and offer Renato Renato Olivei

Re: [ADMIN] Migrate postgres to newer hardware

Slony and Bucardo but have not heard of Londiste before. How many people are using all three of them and their review have you heard anything about that? Thank you again Really Appreciate it Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763

Re: [ADMIN] Migrate postgres to newer hardware

sorry for this Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 www.grant.co.uk<http://www.grant.co.uk/> Grant Instruments (Cambridge) Ltd Company registered in England, registration number 658133 Registered

Re: [ADMIN] Migrate postgres to newer hardware

because I have been checking it and it has been growing steadily. We must migrate to newer and better optimized hardware. Thank you again Much appreciated. Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http

Re: [ADMIN] Migrate postgres to newer hardware

transactions since last backup and restore to the new server or ‘append’ to the new server. I think this should be possible to do. Thank you very much for all your support and help, really appreciated. Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0

[ADMIN] List of postgreSQL databases

dvance. Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 www.grant.co.uk<http://www.grant.co.uk/> Grant Instruments (Cambridge) Ltd Company registered in England, registration number 658133 Registered offic

Re: [ADMIN] List of postgreSQL databases

Sergey, Thank you very much, this is more is great. Best regards Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/ Grant Instruments (Cambridge) Ltd Company registered in England

Re: [ADMIN] List of postgreSQL databases

Devrim, Thank you very much Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/ Grant Instruments (Cambridge) Ltd Company registered in England, registration number 658133 Registered

[ADMIN] turn pitr 'on' on PostgreSQL 8.2 - pg_standby

ted out #archive_command = '' - disabled and command removed # archive_timeout = 60 - disabled Is this correct, am I missing something or anything here isn't correct? If anyone could give me some light with this it would be very much appreciated.

[ADMIN] Restore data to an existing populated table

help you have given to me, and all the time you spent reading and also replying to my emails. I am learning loads, still loads to learn but I am sure some day I will be helping as well. Thank you very much Best regards Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@g

[ADMIN] archive_timeout - good indication

Dear all, What would be a good indication for 'archive_timeout' on a busy server? Thanks Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 www.grant.co.uk<http://www.grant.co.uk/> Grant Instru

[ADMIN] Admin x DBA

postgres, so the reason I as the questions. If I am asking in the wrong list, I apologise. Thank you very much Bets regards Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 www.grant.co.uk<http://www.grant.co

Re: [ADMIN] archive_timeout - good indication

uestion is does it copy the logs as well as compresses it, because there is an example: archive_command = 'pg_compresslog "%p" /"%f"' Is this instead of using 'cp'? Thank you very much Best regards Renato Renato Oliveira Systems Administrator e-mail: re

Re: [ADMIN] Admin x DBA

Hi Kevin, I actually just realised I did not specifically said "Systems Administrator" and this is what I was refereeing to. Systems Admin x DBA. Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 2

[ADMIN] 'COPY' Statement

it, will be minimum, and easy to and quick to 'COPY' This application has two part components (Data and Alarms) We can get the data back in a very hard way, but without the data being in the database we can't generate alarms. I would very much appreciate all your help on this id

[ADMIN] archived WALL files question

How do you guys deal with this problem? Thank you very much in advance Best regards Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 www.grant.co.uk<http://www.grant.co.uk/> Grant Instruments (Cambridge) Lt

Re: [ADMIN] archived WALL files question

e the reason(s) for you to do weekly base backups? Thank you very much Best regards Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/ Grant Instruments (Cambridge) Ltd Company register

Re: [ADMIN] archived WALL files question

n Road, Shepreth, CAMBS SG8 6GB UK From: Vitaly Burshteyn [mailto:vbursht...@broadway.com] Sent: 15 April 2010 17:08 To: scott.li...@enterprisedb.com; Renato Oliveira Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] archived WALL files question We manage the WAL files via skytools WALMGR As far

Re: [ADMIN] archived WALL files question

ve to play one year worth of logs. It is an interesting setup you have there, but you must have loads of space for all of those backups. How long does it take for base backup of one of your busy DBs? Thank you Very much Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.

[ADMIN] Tail -f or watch for postgres

entries rolling and being displayed on screen. Is there something similar to postgreSQL? Thank you very much Best regards Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 www.grant.co.uk<http://www.grant.co

[ADMIN] "duplicate key value violates unique constraint" ERROR

could think. Thank you very much Best regards Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 www.grant.co.uk<http://www.grant.co.uk/> Grant Instruments (Cambridge) Ltd Company registered in Englan

Re: [ADMIN] "duplicate key value violates unique constraint" ERROR

Ian, Thank you very much for your reply. Really appreciated it. Thank you Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/ Grant Instruments (Cambridge) Ltd Company registered in

[ADMIN] 6 SCSI Disks RAID 10 x 2 SCSI DISKS RAID1 + 4 SCSI Disks RAID 10

with a single controller, how good that will be? How do you guys have your RAIDS setup? Thank you Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 www.grant.co.uk<http://www.grant.co.uk/> Grant Instr