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
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
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
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
--
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
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
-- 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
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