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
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
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
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
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
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
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
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
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
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
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
? 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
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
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
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
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
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
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
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
.
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
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
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
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/
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
47 matches
Mail list logo