[ADMIN] Postgresql 8.4 pam

2009-09-29 Thread Jakub Gołębiewski
Hi, I'm trying to configure authentication to postgresql 8.4 on FreeBSD Current with pam, but when I restart the server I can't login into database using pam authentication. My pg_hba.conf looks: local all all md5 hostall all 192.168.1.0/24 pam pamservice=/etc/pam.d/postgres and my

Re: [ADMIN] Postgresql 8.4 pam

2009-09-29 Thread Tom Lane
=?ISO-8859-2?Q?Jakub_Go=B3=EAbiewski?= writes: > I'm trying to configure authentication to postgresql 8.4 on FreeBSD Current > with pam, but when I restart the server I can't login into database using > pam authentication. You'll need to check your PAM documentation, but if this is trying to read

[ADMIN] Postgres server goes in recovery mode repeteadly

2009-09-29 Thread kunal sharma
Hi , We are using Postgres 8.4 and its been found going into recovery mode couple of times. The server process seems to fork another child process which is another postgres server running under same data directory and after some time it goes away while the old server is still running. There

Re: [ADMIN] [HACKERS] Postgres server goes in recovery mode repeteadly

2009-09-29 Thread Andrew Dunstan
kunal sharma wrote: Hi , We are using Postgres 8.4 and its been found going into recovery mode couple of times. The server process seems to fork another child process which is another postgres server running under same data directory and after some time it goes away while the old se

Re: [ADMIN] Postgres server goes in recovery mode repeteadly

2009-09-29 Thread Tom Lane
kunal sharma writes: > We are using Postgres 8.4 and its been found going into recovery 8.4.what? (If not 8.4.1, an update would be the first thing to try.) > Checking the logs I found that theres a segmentation fault , > Sep 26 05:39:54 pace kernel: postgres[28694]: segfault at 00

Re: [ADMIN] [HACKERS] Postgres server goes in recovery mode repeteadly

2009-09-29 Thread kunal sharma
gdb backtrce- (gdb) bt full #0 0x2ad6d7b8c2b3 in __select_nocancel () from /lib64/libc.so.6 No symbol table info available. #1 0x005a39bc in ServerLoop () at postmaster.c:1304 timeout = {tv_sec = 55, tv_usec = 352000} rmask = {fds_bits = {24, 0 }} selres =

Re: [ADMIN] [HACKERS] Postgres server goes in recovery mode repeteadly

2009-09-29 Thread Tom Lane
kunal sharma writes: > gdb backtrce- > (gdb) bt full > #0 0x2ad6d7b8c2b3 in __select_nocancel () from /lib64/libc.so.6 > No symbol table info available. > #1 0x005a39bc in ServerLoop () at postmaster.c:1304 > timeout = {tv_sec = 55, tv_usec = 352000} I think what you're show

Re: [ADMIN] Postgresql 8.4 pam

2009-09-29 Thread Alvaro Herrera
Jakub Gołębiewski escribió: > when i try to connetc from remote host I get information: psql: FATAL: PAM > authentication failed for user "golebiej" Please try psql -W -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.

Re: [ADMIN] Data problem - error "invalid attribute number # for "

2009-09-29 Thread Sebastien Boisvert
> >>> Some poking through the source code finds only one match for that error >>> message, which is in relcache.c. It looks like you have a row in >>> pg_attribute that claims to belong to that relation, but has attnum >>> 32533. It would be interesting to see the results for >>> select * fr

Re: [ADMIN] Data problem - error "invalid attribute number # for "

2009-09-29 Thread Tom Lane
Sebastien Boisvert writes: >> Hmm, no sign of any such row here ... try reindexing pg_attribute. > It gets more interesting: > MCS=# reindex table pg_attribute; > ERROR: could not access status of transaction 276828288 > DETAIL: Could not open file "pg_subtrans/1080": No such file or directory

[ADMIN] high loads, fine tuning

2009-09-29 Thread Aras Angelo
I have this server, Dual Intel Xeon 2.83GHz w 4gb ram. My shared buffers were set to 1756 MB. We have a high traffic e-commerce site, yesterday like 8 uniques. We cache most of our dynamic pages to disk so its wierd we are experience really slow response times with postgresql. Usually the num

Re: [ADMIN] high loads, fine tuning

2009-09-29 Thread lst_hoe02
Zitat von Aras Angelo : I have this server, Dual Intel Xeon 2.83GHz w 4gb ram. My shared buffers were set to 1756 MB. We have a high traffic e-commerce site, yesterday like 8 uniques. We cache most of our dynamic pages to disk so its wierd we are experience really slow response times with p

Re: [ADMIN] high loads, fine tuning

2009-09-29 Thread Aras Angelo
Sorry i forgot to mention it, max cli setting is 500. On Tue, Sep 29, 2009 at 12:07 PM, wrote: > Zitat von Aras Angelo : > > I have this server, Dual Intel Xeon 2.83GHz w 4gb ram. >> My shared buffers were set to 1756 MB. >> >> We have a high traffic e-commerce site, yesterday like 8 unique

[ADMIN] save db

2009-09-29 Thread Darcy Larangeira
Hi!I'd like to know howto save ex. my_db in a private file in order to move it to another server as soon as I finishthe program. Is it possible? I 've looked for this information at some tutorialsbut it seems I do not know how to look for.Waiting for helpt, I thank very much in advance. Darcy Lar

Re: [ADMIN] save db

2009-09-29 Thread Richard Broersma
On Tue, Sep 29, 2009 at 2:58 PM, Darcy Larangeira wrote: > I'd like to know howto save ex. my_db in a private file > in order to move it to another server as soon as I finish > the program. Is it possible? I 've looked for this information at some > tutorials > but it seems I do not know how to