[ADMIN] pg_dump formatting

2009-03-19 Thread Caleb Cushing
is there any way to format the output of pg_dump? in a way that is more diff-able? like line wrap on each row, record or something? that way you can easily find the differences of each dump if need be? -- Caleb Cushing http://xenoterracide.blogspot.com -- Sent via pgsql-admin mailing list (pgs

Re: [ADMIN] out of memory

2009-03-19 Thread Vladimir Rusinov
On Fri, Mar 13, 2009 at 11:15 PM, Fabricio wrote: > > Hello... > > Linux 2.6.27.6 #7 SMP Sun Nov 16 00:48:35 MST 2008 i686 i686 i386 GNU/Linux > Slackware 11 and Postgres 8.1.15 > Go download 64-bit OS. -- Vladimir Rusinov http://greenmice.info/

Re: [ADMIN] Connection limit per user

2009-03-19 Thread Vibhor Kumar
Hello Lukas, You would be able to achieve it using the alter user command as given below: alter user with CONNECTION LIMIT 2; Lukas wrote: Hello, is here any way to set connection limit to database per database user? For ex. if I have postgresql database user XXX I want limit it to 2 conne

[ADMIN] Connection limit per user

2009-03-19 Thread Lukas
Hello, is here any way to set connection limit to database per database user? For ex. if I have postgresql database user XXX I want limit it to 2 connections per database (or per all databases).. -- Lukas UAB nSoft http://www.nsoft.lt Lukas at nsoft.lt +370 655 10 655 -- This message has b