Re: [ADMIN] Blob error after backup and restore [database > 5.5 Gb.]

2005-06-14 Thread Tom Lane
"Amrit Angsusingh" <[EMAIL PROTECTED]> writes: > after I try to restore it in another server which has the same environment > [via nfs] and use the command > pg_restore -d test test.tar > The database "test" after restoration has the same data but no blob > found . Another thought here: what exac

Re: [ADMIN] Connecting via localhost pg-8.0.3

2005-06-14 Thread Tom Lane
David <[EMAIL PROTECTED]> writes: > I've just upgraded from 7.4.7 to 8.0.3. On what platform, and how did you build or obtain each of these PG versions? > I get the following error if I omit "host=localhost" : > Warning: pg_connect(): Unable to connect to PostgreSQL server: could > not connect

[ADMIN] DEADLOCK INSERT

2005-06-14 Thread Ricardo Durao
Hello, Tom Lane I am using version 7.4.8 and I think that I have this problem(bug) that is describe here for you. _ Re: INSERT deadlocks (bug or feature?) From: Tom Lane To: evgeny gridasov Subject: Re: INSERT d

[ADMIN] Blob error after backup and restore [database > 5.5 Gb.]

2005-06-14 Thread Amrit Angsusingh
I have postgresql data [7.4.3] on fedora 3 which has the size of more than 5 Gb. and also contains blob for reporting. I use the command pg_dump -Ft -b homc > homc.tar test.tar > 5.5 Gb. after I try to restore it in another server which has the same environment [via nfs] and use the command

[ADMIN] Connecting via localhost pg-8.0.3

2005-06-14 Thread David
I'm not sure to what list this question belongs, but here goes. I've just upgraded from 7.4.7 to 8.0.3. All seems to have upgraded well but I've stumbled across one thing I don't understand. It now seems that I have to include host=localhost in the pg_connect params from a php script, whereas th

Re: [ADMIN] max_fsm_pages

2005-06-14 Thread Bruce Momjian
Dextra - Gustavo Bartz Guedes wrote: > Is the parameter max_fsm_pages cluster-wide or per-database? cluster-wide. -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Roa

[ADMIN] max_fsm_pages

2005-06-14 Thread Dextra - Gustavo Bartz Guedes
Is the parameter max_fsm_pages cluster-wide or per-database? Thanks. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Remote Access

2005-06-14 Thread Chris Browne
Marcos <[EMAIL PROTECTED]> writes: > I have one server postgresql in my home computer, and now I have the > necessity of access it of my work, the question is. How I liberate > the access remote of postgresql with password? Is there some reason why Chapter 19 in the documentation, entitled "Client

Re: [ADMIN] Remote Access

2005-06-14 Thread Dorian =?ISO-8859-15?Q?B=FCttner?=
Marcos wrote: > Hello, > > I have one server postgresql in my home computer, and now I have the > necessity of access it of my work, the question is. How I liberate the > access remote of postgresql with password? > pghba.conf? ---(end of broadcast)--

Re: [ADMIN] reading vacuum verbose output

2005-06-14 Thread Tom Lane
Tsirkin Evgeny <[EMAIL PROTECTED]> writes: > INFO: --Relation public.student2maslulsign_rashum_musmach_old-- > INFO: Pages 906: Changed 0, Empty 0; Tup 846: Vac 0, Keep 0, UnUsed 96035. > Total CPU 0.03s/0.01u sec elapsed 0.04 sec. > If there are unused tuples why i see the Changed 0 ?

[ADMIN] reading vacuum verbose output

2005-06-14 Thread Tsirkin Evgeny
Hello list! I have run a vacuum verbose on a db and got something a can't understand by myself : INFO: Pages 4768: Changed 0, Empty 0; Tup 4764: Vac 0, Keep 0, UnUsed 542404. Total CPU 0.35s/0.00u sec elapsed 1.51 sec. INFO: --Relation public.student2maslulsign_rashum_musmach_old-- IN