Re: [GENERAL] Blocking access by remote users for a specific time period

2014-12-13 Thread Michael Nolan
Yeah, a cron job to swap pg_hba.conf files is the best solution I've come up with so far. It's not one web app, it's closer to two dozen of them, on multiple sites. -- Mike Nolan On Sat, Dec 13, 2014 at 11:10 PM, Adrian Klaver wrote: > > On 12/13/2014 08:13 PM, Michael Nolan wrote: > >> I have s

Re: [GENERAL] Error: "Out of memory while reading tuples." in pushing table from SAS to PostgreSQL on Mac

2014-12-13 Thread Adrian Klaver
On 12/13/2014 08:03 PM, wetter wetterana wrote: Hi, I'm passing rows from SAS to PostgreSQL (I assign a libname and use a PROC APPEND). This works fine with smaller tables (~below 1 million rows). However, as tables get larger I receive the following error messages: This will need some more

Re: [GENERAL] Blocking access by remote users for a specific time period

2014-12-13 Thread Adrian Klaver
On 12/13/2014 08:13 PM, Michael Nolan wrote: I have several web apps that access our Postgresql database that I'd like to lock out of the database for about an hour during a weekly maintenance interval. (There are some internal users that do not get locked out, because they're running the mainten

Re: [GENERAL] Blocking access by remote users for a specific time period

2014-12-13 Thread Rob Sargent
Turn the app off? Seems that's one of the selling points of web apps. Throw up a "under maint" page. Sent from my iPhone > On Dec 13, 2014, at 9:13 PM, Michael Nolan wrote: > > I have several web apps that access our Postgresql database that I'd like to > lock out of the database for about

[GENERAL] Blocking access by remote users for a specific time period

2014-12-13 Thread Michael Nolan
I have several web apps that access our Postgresql database that I'd like to lock out of the database for about an hour during a weekly maintenance interval. (There are some internal users that do not get locked out, because they're running the maintenance tasks.) There are no time-of-day access l

[GENERAL] Error: "Out of memory while reading tuples." in pushing table from SAS to PostgreSQL on Mac

2014-12-13 Thread wetter wetterana
Hi, I'm passing rows from SAS to PostgreSQL (I assign a libname and use a PROC APPEND). This works fine with smaller tables (~below 1 million rows). However, as tables get larger I receive the following error messages: "ERROR: CLI describe error: Out of memory while reading tuples.; No query ha

Re: [GENERAL] Database and OS monitoring

2014-12-13 Thread Andy Colson
On 12/13/2014 12:55 PM, Edson Carlos Ericksson Richter wrote: Dear list, I've been searching in web for guidelines on OS (Linux) and PostgreSQL (9.3.5) active monitoring best practices. Can someone share experiences? I'm inclined to look at Cacti and Nagios. Any other experiences? Recommended

Re: [GENERAL] Database and OS monitoring

2014-12-13 Thread John R Pierce
On 12/13/2014 10:55 AM, Edson Carlos Ericksson Richter wrote: I've been searching in web for guidelines on OS (Linux) and PostgreSQL (9.3.5) active monitoring best practices. Can someone share experiences? I'm inclined to look at Cacti and Nagios. Any other experiences? Recommended books? I don

[GENERAL] Database and OS monitoring

2014-12-13 Thread Edson Carlos Ericksson Richter
Dear list, I've been searching in web for guidelines on OS (Linux) and PostgreSQL (9.3.5) active monitoring best practices. Can someone share experiences? I'm inclined to look at Cacti and Nagios. Any other experiences? Recommended books? I don't want to use SaaS for monitoring - I'll have a c

Re: [GENERAL] pgbench

2014-12-13 Thread alikon
Hi, can you share the plsql procedure to call the query from pgbench i'm running in the same issue cause i have a long query that i want to submit to pgbench There are any news for fix this pgbench issue ? -- View this message in context: http://postgresql.nabble.com/pgbench-tp5773225p5830455