Re: [pgadmin-support] Out of memory (failed on request)

2014-04-23 Thread J.F. Oster
Hello HappyGirl84, This list is for pgAdmin, the GUI administrative tool for PostgreSQL. For questions such as yours, which relate to Postgres itself, you'd better post to the pgsql-general list. May be this will help: Check configuration parameter 'maintenance_work_mem' by issuing following in

[pgadmin-support] Out of memory (failed on request)

2014-04-23 Thread HappyGirl84
Im running a PostgreSQL database (pokerdatabase with HoldemManager) and trying to vacuum it with pgadmin III, but I keep getting the same error message (out of memory, detail: Failed on request of size 268435456). I can read that I should try lower the "working memory", but how do I do that? I got

Re: [pgadmin-support] WAL archiving from a standby backup strategy Postgresql 9.3

2014-04-23 Thread Raymond O'Donnell
On 23/04/2014 16:37, Kal Black wrote: > Hello > I am trying to figure out if wal archiving from a standby is possible > and a viable option for a backup strategy on Postgresql 9.3. The idea is > to be able to take regular base backups and wal archives from a standby > server in a remote DR site. Un

[pgadmin-support] WAL archiving from a standby backup strategy Postgresql 9.3

2014-04-23 Thread Kal Black
Hello I am trying to figure out if wal archiving from a standby is possible and a viable option for a backup strategy on Postgresql 9.3. The idea is to be able to take regular base backups and wal archives from a standby server in a remote DR site. Unfortunately, the archive_command functionality i

Re: [pgadmin-support] using ssh-agent

2014-04-23 Thread berenger . morel
Sorry for long time before replying, I have lot of things to do those days... Your solutions sounds like an interesting one, I'll give it a try when I will have some time. I'm still not an expert about ssh, so I did not thought/known about port redirection. Le 18.04.2014 16:38, Rick Dicaire