Hello,
I am interested in the file system level backup:
http://www.postgresql.org/idocs/index.php?backup-file.html
Is there any documentation/ suggestions on restoring file system backups.
Thanks.
Joyce Yuen
_
¦b http://ex
At the moment I try to write a concept for testing databases (postgresql and
sybase). the databases are used to learn. Wiches kind of test parameters
(performance, stresstests, balancing) would you use.
mfg diego
---(end of broadcast)---
TIP 1:
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
> I am interested in the file system level backup:
>
> http://www.postgresql.org/idocs/index.php?backup-file.html
>
> Is there any documentation/ suggestions on restoring file system
> backups.
It would be identical to Oracle's cold backup strategy (about which I'm
sure you'll find volumes o
Being fairly new to postgresql, I have a couple of questions on pg_xlog
We are on 7.2.1
1. How does one properly administer the pg_xlogs? -- How long to retain
them?
Is it ok to delete them after a period of time? If so, what period of
time?
2. I understand that the numbering scheme do
Pam Wampler wrote:
> Being fairly new to postgresql, I have a couple of questions on pg_xlog
> We are on 7.2.1
>
> 1. How does one properly administer the pg_xlogs? -- How long to retain
> them?
> Is it ok to delete them after a period of time? If so, what period of
> time?
It is auto-c
What err ?
Order By (Sum(Qtde)/(1+current_date-Max(Data)))
Desc
Regards,
Robson
What err ?
Order By (Sum(Qtde)/(1+current_date-Max(Data)))
Desc
Regards,
Robson
I've looked around a lot and don't think this is possible with Postgres, but
figured I would ask in case I missed something. Is it possible to configure
things so that an index resides on a separate disk ? It doesn't look like it,
since they both have to reside in the same database, and the ent
I just used Dezign for Databases and created a simple table in what it
claimed was "ANSI Level 2" compliance with a one-up "autonum" column.
It spewed forth the following code:
-- file generated by "dezign for databases"
-- create-date:6/13/2002
Robson-
In this, and your last question, the problem is that you are using functions
from Microsoft Access. You'll keep running into this until you learn about
the equivalent functions in PostgreSQL.
The PostgreSQL functions are explained here:
http://www.postgresql.org/idocs/index.php?functions
On Thu, 13 Jun 2002, Tim Ellis wrote:
> I just used Dezign for Databases and created a simple table in what it
> claimed was "ANSI Level 2" compliance with a one-up "autonum" column.
>
> It spewed forth the following code:
>
> -- file generated by "dezign for databases"
> -- create-date:6/1
Tim Ellis <[EMAIL PROTECTED]> writes:
> I just used Dezign for Databases and created a simple table in what it
> claimed was "ANSI Level 2" compliance with a one-up "autonum" column.
There is no such animal as "ANSI Level 2" SQL.
> create trigger transaction_autonum_inc
> before insert on tran
On Thu, Jun 13, 2002 at 12:49:39PM -0700, Charlie Toohey wrote:
> I've looked around a lot and don't think this is possible with Postgres, but
> figured I would ask in case I missed something. Is it possible to configure
> things so that an index resides on a separate disk ? It doesn't look like
> > I just used Dezign for Databases and created a simple table in what it
> > claimed was "ANSI Level 2" compliance with a one-up "autonum" column.
>
> There is no such animal as "ANSI Level 2" SQL.
That explains a lot of things. About this DDL problem and Dezign for
Databases both.
> > set (
Tim Ellis <[EMAIL PROTECTED]> writes:
> Yeh. Good question. I would assume their generator MEANT
> (max(autonum,0)+1) supposing that a "ANSI Level 2"-compliant server's
> max function might return the second value if the first is NULL. But no
> matter how you slice it, that looks syntactically wro
=?iso-8859-1?Q?Ragnar_Kj=F8rstad?= <[EMAIL PROTECTED]> writes:
> On Thu, Jun 13, 2002 at 12:49:39PM -0700, Charlie Toohey wrote:
>> I've looked around a lot and don't think this is possible with Postgres, but
>> figured I would ask in case I missed something. Is it possible to configure
>> things
19 matches
Mail list logo
