Re: [ADMIN] [GENERAL] WARNING: database must be vacuumed within 8439472 transactions

2014-07-07 Thread Frank Pinto
That actually sounds terrifying. I'd throw up a caching layer ASAP to try to decrease the speed those transactions are happening. Frank On Mon, Jul 7, 2014 at 2:25 PM, Nicolas Zin < nicolas@savoirfairelinux.com> wrote: > Maybe you can priorize your worker with a ionice? > > - Mail origi

Re: [GENERAL] Petition: Treat #!... shebangs as comments

2014-07-18 Thread Frank Pinto
I personally like Francisco Olarte's approach. Hashbang's don't support arguments well ( http://stackoverflow.com/questions/4303128/how-to-use-multiple-arguments-with-a-shebang-i-e) and being able to put JUST psql as the command to execute the script doesn't scale across environments. Previously I'

Re: [GENERAL] Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method

2014-08-06 Thread Frank Pinto
Looks like you're doing it right, you actually have to specify the user though: psql -U postgres and make sure you restarted the server so your changes take effect. Frank On Wed, Aug 6, 2014 at 4:43 PM, Jorge Arevalo wrote: > Hello, > > I want to connect to my local installation of PostgreSQ

Re: [GENERAL] PostgreSQL on AIX platform

2014-08-08 Thread Frank Pinto
Payal, I think you completely ignored john r pierce...any reason you're using 9.2.4? Whoevers going to help you will want to be testing on what you're eventually going to compile Frank On Fri, Aug 8, 2014 at 4:54 PM, Payal Shah wrote: > Hello John, > > > > Thank you for your response. If you