Обсуждение: setting -i and -N 100 when starting postmaster
Hi all, My wonderful colleagues in charge of our production database have screwed up royally. They managed to corrupt the productiondatabase by having two instances of postgresql talking to the same database/same filesystem/same time. Now, they'd like me to fix it. Sigh... BTW, this is a V9.2.2 system, and the database will still start, but the logs are full of reports pf invalid page headererrors. One thing I'm looking at is doing a "ps -ef | grep postmaster", I see "service postgresql-9.2 start" uses: postmaster -D /opt/datacenter -i -N 384 -p 5431 Now, I know what the -D and -p are doing, but I'm not sure what -i and -N are for, and my internet search hasn't turned upmuch. Anybody know? -- Jay PS. Any suggestions beyond setting zero_damaged_pages=true and then running a vacuum would also be appreciated.
-i is "interactive," as in "listen on TCP/IP"
-N 384 is max connections 384
Hi all,My wonderful colleagues in charge of our production database have screwed up royally. They managed to corrupt the production database by having two instances of postgresql talking
to the same database/same filesystem/same time. Now, they'd like me to fix it. Sigh...BTW, this is a V9.2.2 system, and the database will still start, but the logs are full of reports pf invalid page header errors. One thing I'm looking at is doing a "ps -ef | grep
postmaster", I see "service postgresql-9.2 start" uses:postmaster -D /opt/datacenter -i -N 384 -p 5431Now, I know what the -D and -p are doing, but I'm not sure what -i and -N are for, and my internet search hasn't turned up much. Anybody know?
--
JayPS. Any suggestions beyond setting zero_damaged_pages=true and then running a vacuum would also be appreciated.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Jul 16, 2014, at 3:40 PM, John Scalia <jayknowsunix@gmail.com> wrote: > > postmaster -D /opt/datacenter -i -N 384 -p 5431 > > Now, I know what the -D and -p are doing, but I'm not sure what -i and -N are for, and my internet search hasn't turnedup much. Anybody know? $ postmaster —help
Вложения
Thanks all, I've just never set those options. On 7/16/2014 3:49 PM, Ray Stell wrote: > On Jul 16, 2014, at 3:40 PM, John Scalia <jayknowsunix@gmail.com> wrote: >> postmaster -D /opt/datacenter -i -N 384 -p 5431 >> >> Now, I know what the -D and -p are doing, but I'm not sure what -i and -N are for, and my internet search hasn't turnedup much. Anybody know? > $ postmaster —help > >
John Scalia <jayknowsunix@gmail.com> writes: > My wonderful colleagues in charge of our production database have screwed up royally. They managed to corrupt the productiondatabase by having two instances of postgresql talking > to the same database/same filesystem/same time. Now, they'd like me to fix it. Sigh... Just outta curiosity, how'd they do that? There are interlocks that are supposed to prevent it. You can defeat the interlocks by manually deleting the postmaster lock file, which is why you're *never* supposed to do that. I'm curious if they did that, or found some new way. regards, tom lane