Re: [ADMIN] postmaster is restarting

2013-04-29 Thread Rodrigo Barboza
On Mon, Apr 29, 2013 at 7:48 PM, Johnny Tan wrote: > Chef or Puppet? > > > On Mon, Apr 29, 2013 at 5:48 PM, Lou Picciano wrote: > >> You probably have a service with overarching control over PostgreSQL. >> Gonna depend on how you installed PostgreSQL, which distro you've >> installed, etc... >> >

Re: [ADMIN] postmaster is restarting

2013-04-29 Thread Johnny Tan
Chef or Puppet? On Mon, Apr 29, 2013 at 5:48 PM, Lou Picciano wrote: > You probably have a service with overarching control over PostgreSQL. > Gonna depend on how you installed PostgreSQL, which distro you've > installed, etc... > > > - Original Message - > From: Rodrigo Barboza > To: p

Re: [ADMIN] postmaster is restarting

2013-04-29 Thread Lou Picciano
You probably have a service with overarching control over PostgreSQL. Gonna depend on how you installed PostgreSQL, which distro you've installed, etc... - Original Message - From: Rodrigo Barboza To: pgsql-admin@postgresql.org Sent: Mon, 29 Apr 2013 21:35:08 - (UTC) Subject: [ADMIN]

Re: [ADMIN] postmaster is restarting

2013-04-29 Thread Lonni J Friedman
On Mon, Apr 29, 2013 at 2:35 PM, Rodrigo Barboza wrote: > Hi, guys. > I am using the script that comes with postgres installation to start and > stop my database. > When I stop the database, it restarts after some minutes. > I have looked through every path and I don't find who starts it again. >

[ADMIN] postmaster is restarting

2013-04-29 Thread Rodrigo Barboza
Hi, guys. I am using the script that comes with postgres installation to start and stop my database. When I stop the database, it restarts after some minutes. I have looked through every path and I don't find who starts it again. I am using Linux. Is there some kind of signaling to for it to restar

Re: [ADMIN] Postgresql Courses

2013-04-29 Thread Isabella Ghiurea
Hi, check Enterprise DB website (see link ) for on- demand DBA PG SQL admin training, I found them pretty good compared with other two N. America vendors which will provide same web based class in English and Spanish.. http://www.enterprisedb.com/store/products/dba-training Isabella --

[ADMIN] PANIC during VACUUM

2013-04-29 Thread German Becker
Hi, I am testing version 9.1.9 before putting it in production. One of my tests involved deleting a the contents of a big table ( ~ 13 GB size) and then VACUUMing it. During VACUUM PANICS. Here is the message: PANIC: corrupted item pointer: offset = 8128, size = 80 I found the error a couple of