[GENERAL] doubt about pg_dumpall

2004-04-19 Thread javier garcia - CEBAS
Hi all; In the documentation I'm missing some explanation about pg_dumpall. I would like to know if there is any difference if I restore an entire database cluster over an existing database or over an empty cluster. For example: if I restore the database cluster over a database that contains mo

[GENERAL] Problems with pg_dumpall

2004-03-23 Thread javier garcia - CEBAS
Hi; I'm using postgres7.3.4 and I have tried to use pg_dumpall to copya a database from one computer to another. I remember I used it once with no problem, but now I've found a lot of error. I've run the restore as the "postgres" superuser, and it seem that when a table exists previously, or a

Re: [GENERAL] creating sequential timestamp

2004-03-11 Thread javier garcia - CEBAS
l Mar 09 Mar 2004 18:37, Joe Conway escribió: > javier garcia - CEBAS wrote: > > I've loaded it in the server but when I try to use it exactly as in the > > example Joe gives or in other way I obtain the answer: > > - > > murciadb=# SELECT ts

[GENERAL] creating sequential timestamp

2004-03-08 Thread javier garcia - CEBAS
Hi; Is it possible to directly create postgres tables with a timestamp column with some specific interval and within a specific range. For example every 5 minutes and between the beginning of 1999 and the end of 2003? I just need this column. Thanks for your help. Best regards, Javier --

[GENERAL] starting the server at boot

2003-11-10 Thread javier garcia - CEBAS
Hello; If I add the line: --- su -c 'pg_ctl start -D /usr/local/pgsql/data/ -l /usr/local/pgsql/data/logfile' postgres --- to /etc/rc.d/rd.local. Is there a way this could work when I don't boot as root, but as a common user? (I should be able to automatically p

[GENERAL] Recent installed 7.3.4 startup doubt

2003-08-28 Thread javier garcia - CEBAS
Hello; I've recently installed postgres7.3.4, from the source, (my first time) and just got a good result with the dumpall, thanks to you. I have some problems with the client pgAdminII, bu I guess this is not a proper place to pose those problems. Well, my doubts are: 1) How could I see and ch

[GENERAL] Fwd: installing postgres7.3.4 problem II

2003-08-26 Thread javier garcia - CEBAS
-- Mensaje reenviado -- Subject: installing postgres7.3.4 problem Date: Tue, 26 Aug 2003 18:10:10 +0200 From: javier garcia - CEBAS <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Hi all. (I'm a newby. I recognize it) At the

[GENERAL] numeric formats in SELECT

2003-07-01 Thread javier garcia - CEBAS
Hi all; I've got a table with real type data. And, in the SELECT, some of the columns are displayed in scientific format. I don't like this, and I would prefer that the number were shown with two decimal digits. Is this possible? Best regards Javier ---(end of broadcas