"Thilina Gunasekara" <[EMAIL PROTECTED]> writes:
> I have two PostgreSQL Database Servers running on Gentoo which versions are
> PostgreSQL 7.4.5 (Box A) and PostgreSQL 7.3.9 (Box B)
> Due to a recent query posted by a developer I was interested to know which
> factors are affecting these two serve
Bruce Momjian wrote:
> Tom Lane wrote:
> > Bruce Momjian writes:
> > > I am now thinking we need to make this "10" a GUC variable for just such
> > > cases. This is not the first request for this.
> >
> > At most it's the second or third request ... and this is hardly the only
> > repetitive dis
Dear All,
I have two PostgreSQL Database Servers running on Gentoo which versions are
PostgreSQL 7.4.5 (Box A) and PostgreSQL 7.3.9 (Box B)
Due to a recent query posted by a developer I was interested to know which
factors are affecting these two servers to behave in a different manner to
the sam
I have just installed PostgreSQL (postgresql-8.0.1.zip) on a Windows 2K Prof
platform.
but the the default Database Dir is in C:\Program Files\PostgreSQL\8.0\data
can I move the default Database ex: D:\DataPG\
where can i set it??
Thank You for all your kind for reading my bad english email
On Mon, Mar 21, 2005 at 05:12:52PM +0100, [EMAIL PROTECTED] wrote:
>
> I have a table where an oid field is used for saving images. I'm thinking
> about getting a little snapshot of all images without downloading the full
> images. I only want to download some entire images. I'm thinking in someth
On Wed, Mar 23, 2005 at 02:07:03PM -0800, David B wrote:
> .info administrator might be dealing with 100 transactions per
> hour...or per second. Not seen anything on that. And a few hundred
The short answer to this is "both" (I am one of those .info people.
Also .org, .in, and a bunch of others)
On Wed, Mar 23, 2005 at 05:12:37PM -0300, Joao Daniel wrote:
> Hy guys, where can I find some information over clustering postgreSQL ?
And by "clustering" you mean what, precisely? If you mean "many
machines with one postmaster" the really short version is that you
can't really do this today.
A
"Joseph M. Day" <[EMAIL PROTECTED]> writes:
> It looks like pg_dump is the equivalent of a full backup, but
> how do I keep the equivalent of a Incremental, or Differential backup.
The only built-in mechanism for incremental backups at the moment is
archiving WAL logs via PITR. See
http://www.pos
you'll probably find some answers in the comments of a similar Slashdot post:
http://it.slashdot.org/article.pl?sid=05/03/21/1635210
Check out http://advocacy.postgresql.org
Two other examples are Whitepages.com (375GB) and the .org registry as well.
On Wed, March 23, 2005 17:07, David B said:
I've been looking for examples of high volume (in terms of throughput)
and large scale (500GB-terabtype+) examples of Postgres
impllmenetations.
I keep seeing the same few examples (BASF, Los Alamos Labs, Futijsu
and .info administrator). Impossible to tell anything from the names.
.info administr
> Is there anybody using this for large DB's? Anything larger than a
> couple hundred GB, it would be impractical to make full backups
> everyday. Anyone out there using this for large DB's, if so I'd love to
> hear how they are dealing with backups.
You might want to have a look at this:
ht
If you are running version 8, you may want to look into the WAL archiving:
http://www.postgresql.org/docs/8.0/interactive/backup-online.html
That would form the basis of your incremental backup strategy. I haven't had
the joy of using them myself however, and do not know of any tools to make it
Joseph M. Day wrote:
I am trying to convert a MSSQL DB thats roughly 45GB, to Postgres. I
am trying to find the equivalent of Full / Incremental / Differential
backups. It looks like pg_dump is the equivalent of a full backup, but
how do I keep the equivalent of a Incremental, or Differential b
Joseph M. Day wrote:
>> I am trying to convert a MSSQL DB thats roughly 45GB, to Postgres. I
>> am
>> trying to find the equivalent of Full / Incremental / Differential
>> backups. It looks like pg_dump is the equivalent of a full backup,
but
>> how do I keep the equivalent of a Incremental, or
Title: Message
I am
trying to convert a MSSQL DB thats roughly 45GB, to Postgres. I am trying to
find the equivalent of Full / Incremental / Differential backups. It looks
like pg_dump is the equivalent of a full backup, but how do I keep the
equivalent of a Incremental, or Differential bac
Hy guys, where can I find some information over clustering postgreSQL ?
Yahoo! Acesso Grátis: Internet rápida e grátis. Instale o discador agora!
In fact, I was not using an administrative user but a user with special
rights. I tried with a simple user and the initdb runned correctly.
Thanks a lot !
-
Well, my French isn't as good as I'd like :) but it looks as though you're
trying to set up the d
Well, my French isn't as good as I'd like :) but it looks as though you're
trying to set up the database as an administrator. As this creates various
security risks, it's not allowed. You probably created a user account
during PostgreSQL installation. If you run initdb as that user, you should
Hello,
I have just installed PostgreSQL (postgresql-8.0.1.zip) on a Windows XP
(SP1) platform.
After the installation I runned the following command :
initdb -D D:\Bureautique\PostgreSQL\8.0\bin\Data
but an error occured at the end of the execution. Here is the
message :
Les fichiers appar
19 matches
Mail list logo