[GENERAL] Load Increase

2011-03-29 Thread Ogden
what is a heavy load just by looking at uptime and also what causes the load to increase under reasonably heavy writes? Is it the streaming that could be causing some load increase? Thank you Ogden [3215764.704206] INFO: task postmaster:5087 blocked for more than 120 seconds. [3215764.704236]

Re: [GENERAL] Web Hosting

2011-03-07 Thread Ogden
generous in that arena. > > http://rimuhosting.com/ Something similar is http://www.linode.com/ and even http://www.slicehost.com. I personally have not used either but linode comes with great recommendations from friends. Ogden

Re: [GENERAL] Web Hosting

2011-03-05 Thread Ogden
ere some catch - $5.57 / month for unlimited everything? No hidden anything? Ogden

Re: [GENERAL] PostgreSQL 9.0 Streaming Replication Configuration

2011-02-08 Thread Ogden
too out of sync? How can I best use this tool? Thank you Ogden On Feb 8, 2011, at 8:47 PM, Ray Stell wrote: > > pg_controldata command is helpful. > > Archiving wal not required, but you can roll it either way. > > > > > > > On Tue, Feb 08, 2011 at

Re: [GENERAL] PostgreSQL 9.0 Streaming Replication Configuration

2011-02-08 Thread Ogden
cation lags behind (especially with a lot of connections). Thank you Ogden -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] PostgreSQL 9.0 Streaming Replication Configuration

2011-02-08 Thread Ogden
Hello all, I have set up PostgreSQL Streaming Replication and all seems to work fine when updating records as the records are instantaneously updated on the slave, however, I was wondering perhaps if someone can give me some verification that what I am doing is alright or some more insight into

[GENERAL] mod_perl and PostgreSQL 8.3.3 causing "message type 0x44 arrived from server while idle"

2010-08-18 Thread Ogden
seems that this is thread related. However, what is the culprit here? Apache? mod_perl? Software versions: perl, v5.10.1 (*) built for x86_64-linux-thread-multi and PostgreSQL 8.3.3. Any help is appreciated. Thank you Ogden -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Warm Standby Setup Documentation

2010-03-29 Thread Ogden
On Mar 28, 2010, at 7:45 PM, Yar Tykhiy wrote: > On Fri, Mar 26, 2010 at 01:35:43PM -0500, Ogden wrote: >> On Mar 26, 2010, at 1:32 PM, Greg Smith wrote: >> >>> Bryan Murphy wrote: >>>> The one thing you should be aware of is that when you fail over, your &

Re: [GENERAL] Warm Standby Setup Documentation

2010-03-26 Thread Ogden
On Mar 26, 2010, at 1:32 PM, Greg Smith wrote: > Bryan Murphy wrote: >> The one thing you should be aware of is that when you fail over, your spare >> has no spares. I have not found a way around this problem yet. So, when >> you fail over, there is a window where you have no backups while yo

[GENERAL] Warm Standby Setup Documentation

2010-03-22 Thread Ogden
viable backup/hot spare solution? How has it worked out? Thank you Ogden -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Optimizations

2010-03-05 Thread Ogden
On Mar 5, 2010, at 2:26 AM, Craig Ringer wrote: > Ogden wrote: >> We run a student scoring system with PostgreSQL as a backend. After the >> results for each student are inputted into the system, we display many >> reports for them. We haven't had a problem with e

[GENERAL] Optimizations

2010-03-05 Thread Ogden
| not null Will it be much faster? I know more storage will be needed. Thank you Ogden -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general