[ADMIN] PostgreSQL & cygwin

2003-10-02 Thread Kerv
Hello, Is any performance degree if I run PostgreSQL from cygwin on a Windows XP machine? thanks. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [ADMIN] initdb error on windows - urgent, please

2003-10-02 Thread Kerv
Jarek Lubczyn'ski wrote: Hi, everybody, Please help me with an urgent problem. I have PostgreSQL version: 7.3.1Alfa1 for Windows (the only Win version available) I am training installation of ProgreSQL on various PC's WinNT, 2K, XP and 2003 installed. In some cases I've got such a problem (till

[ADMIN] Concurrent Connections - User only allowed one connection

2003-10-02 Thread Gordon Ross
(Running PG 7.3.4 on Sparc Solaris 9) I have a Java application (which connects to Postgres using JDBC) which I run from the Solaris box, but which I develop from my desktop PC. When my application connects to Postgres, it can only obtain one connection. i.e. if the server app is running, then my

Re: [ADMIN] PostgreSQL & cygwin

2003-10-02 Thread scott.marlowe
On Thu, 2 Oct 2003, Kerv wrote: > Hello, > > Is any performance degree if I run PostgreSQL from cygwin on a Windows > XP machine? Postgresql is known for poor performance in that situation. But it's plenty good enough for pre-deployment testing and development. ---(e

[ADMIN] Machine name

2003-10-02 Thread Marvin
Hi, I would like to know how could I do to get the host name from postgres.   Something like "CURRENT_HOSTNAME".   Thanx,     MAGO _  IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí

[ADMIN] Current Computer Name

2003-10-02 Thread Marvin Gonzalez
Hi, I would like to know how could I do to get the host name from postgres. Something like "CURRENT_HOSTNAME". Thanx, MAGO -- NEU FÜR ALLE - GMX MediaCenter - für Fotos, Musik, Dateien... Fotoalbum, File Sharing, MMS, Multimedia-Gruß, GMX FotoService Jetzt kostenlos anmelden unte

[ADMIN] Question about DB VACUUM

2003-10-02 Thread Chris White (cjwhite)
Hi, I am using a Postgres 7.2.1 db to store binary data as large objects which users can add or delete as they need. I have found that without frequent vacuums of the database the disk space used by the database grows very quickly, as users on average add and delete binary objects of about 160K at

[ADMIN] pg_restore fails - postgres 7.3.4

2003-10-02 Thread Rob Long
Trying to dump and restore a production database with no success. pg_dump database using the following: pg_dump -v -b -C -Fc -U postgres -f servdb.tar.gz servdb pg_restore with with following: pg_restore -v -C -D template1 -Fc -U postgres servdb.tar.gz restore fails with: pg_restore: [archi

Re: [ADMIN] pg_restore fails - postgres 7.3.4

2003-10-02 Thread Tom Lane
"Rob Long" <[EMAIL PROTECTED]> writes: > Trying to dump and restore a production database with no success. > pg_restore: [archiver (db)] could not execute query: ERROR: data type > integer has no default operator class for access method "gist" Hm, this is probably a matter of incorrect object res

Re: [ADMIN] pg_restore fails - postgres 7.3.4

2003-10-02 Thread Rob Long
Attached. The previously posted index failure stated: CREATE INDEX idx_disc_loc ON order_items USING gist (disc, loc); However in this list it is: CREATE INDEX idx_item_loc ON content_items USING gist (disclosuer, loc); Rob Tom Lane wrote: > "Rob Long" <[EMAIL PROTECTED]> writes: > > Trying to

Re: [ADMIN] Question about DB VACUUM

2003-10-02 Thread Robert Treat
As a starting point, check your free space map settings in the postgresql.conf. They are low by default in 7.2.x. free_space_relations* can safely be bumped to 1000. free_space_pages* should probably be bumped to something like 5, though you might be able to determine a better amount be seeing

Re: [ADMIN] Current Computer Name

2003-10-02 Thread Oliver Elphick
On Thu, 2003-10-02 at 22:47, Marvin wrote: > Because I would like to store in my table the name of the computer > where the user saves the information. > > Whe have already into a MSSQL table the following definition: > > Field name TypeDefault > IngUsernamenvarchar(50)

Re: [ADMIN] pg_restore fails - postgres 7.3.4

2003-10-02 Thread Tom Lane
"Rob Long" <[EMAIL PROTECTED]> writes: >>> Trying to dump and restore a production database with no success. >>> >>> pg_restore: [archiver (db)] could not execute query: ERROR: data type >>> integer has no default operator class for access method "gist" >> >> Hm, this is probably a matter of inco

Re: [ADMIN] Question about DB VACUUM

2003-10-02 Thread Chris White (cjwhite)
I made the changes you suggested and the usage was about the same Initial after vacuum full bash-2.05b# du -s -b /data/sql 57729024/data/sql After 1st iteration bash-2.05b# du -s -b /data/sql 57978880/data/sql 249856 byte increase After 2nd iteration bash-2.05b# du -s -b /data/s

Re: [ADMIN] Question about DB VACUUM

2003-10-02 Thread Tom Lane
"Chris White (cjwhite)" <[EMAIL PROTECTED]> writes: > The index has grown by 4 pages and the table has grown by 10 pages. BTW, > what is a page size? Why is this happening as this is the table that I > am theoretically keeping the same size by adding/deleting the same > objects from. Kinda looks l

Re: [ADMIN] Delete accident

2003-10-02 Thread Gaetano Mendola
Anna Kanevsky wrote: This is an almost embarrassing question, but I managed to delete all rows out of one of the tables by making a little typo in the WHERE statement. When you do update or delete is good do it inside a transaction, I guess you didn't ! I think that your datas are lost. Gaetano

Re: [ADMIN] Question about DB VACUUM

2003-10-02 Thread Chris White (cjwhite)
Tom, You were right, 1 or 2 of the large objects weren't actually getting removed from the table, each cycle. I wasn't running on a completely empty database when I first started, so I didn't notice the undeleted objects. The program which interfaces to the database uses the JDBC method LargeObje

Re: [ADMIN] Delete accident

2003-10-02 Thread Stephan Szabo
On Tue, 30 Sep 2003, Anna Kanevsky wrote: > This is an almost embarrassing question, but I managed to delete all rows > out of one of the tables by making a little typo in the WHERE statement. > Is there any way to restore these? the db was NOT vacuumed after that. but > then, it wasn't backed up

[ADMIN] News group

2003-10-02 Thread Gaetano Mendola
No new messages on the newsgroup! Somethink wrong ? Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get thr