[ADMIN] psql

2001-03-21 Thread Tudor Gabriel PETRESCU
Hello, My name is Tudor,   I tried to acces my data base with the command: psql mydbname and I get the following error message:   Connection to database 'mydbname' failed. connectDB() -- socket() failed: errno=106 Addresses in the specified family cannot be used with this socket   What is

[ADMIN] Disk space

2001-03-21 Thread Kelcey Kornegay
Hello All I have a question about tuning the postgesql database and disk space I attempted to load a very large database into postgresql the process failed. but created several data files in the /data/base/18723 dir. I dropped the table and ran the vacuumdb utility that had worked fine in the pa

[ADMIN] psql

2001-03-21 Thread Tudor Gabriel PETRESCU
Hello, My name is Tudor,   I tried to acces my data base with the command: psql mydbname and I get the following error message:   Connection to database 'mydbname' failed. connectDB() -- socket() failed: errno=106 Addresses in the specified family cannot be used with this socket   What is t

Re: [ADMIN] Re: [SQL] I cannot vacuum

2001-03-21 Thread Jie Liang
Tom, NOTICE: --Relation ip-- NOTICE: Pages 4244: Changed 1, reaped 13, Empty 0, New 0; Tup 665627: Vac 32, Keep/VTL 0/0, Crash 0, UnUsed 594, MinLen 48, MaxLen 48; Re-using: Free/Avail. Space 33168/26016; EndEmpty/Avail. Pages 0/12. CPU 0.32s/2.26u sec. NOTICE: Index ip_ip: Pages 3204; Tuples

Re: [ADMIN] Re: [SQL] I cannot vacuum

2001-03-21 Thread Tom Lane
Jie Liang <[EMAIL PROTECTED]> writes: > Dose later version such as 7.0.3 resolved this problem?? Possibly. Try it and see. You should be running 7.0.3 anyway, just on general principles. regards, tom lane ---(end of broadcast)---