does it do this? Can I control it? Can I turn it off?
--
Evan Rempel, Senior Systems Administrator
University of Victoria
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Alvaro Herrera wrote:
Evan Rempel wrote:
Now to the question.
Once the archive_command starts lying about its success, postgresql deletes
a number of the xlog files that it has been told have been successfuly archived.
Why does it do this? Can I control it? Can I turn it off?
Because
cycling is a function
of checkpoint_segments.)
So it looks like postgresql will try to keep 2.5 * checkpoint_segments files,
and if it has more that have been reported as archived, then it will
start removing them.
Does this sound correct?
--
Evan Rempel
--
Sent via pgsql-admin mailing list (p
142.104.0.0/24MD5
hostall all 142.104.0.0/24ldap...
in hopes that if the account can be authenticated by MD5 local postgresql
accounts, then it is,
otherwise it will be authenticated by ldap.
Is this type of setup possible?
Evan Rempel.
--
Sent via
Well, the list became very quiet on this question. Can anyone chime in with
suggestions to have some accounts authenticated by ldap and the remainder by MD5
Evan.
Evan Rempel wrote:
I would like to use password authentication for most users, but LDAP
authentication for the remaining ones
t is more explicit than what I quoted above.
Thanks so much,
Carol
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Evan Rempel [EMAIL PROTECTED]
Senior Progra
t is more explicit than what I quoted above.
Thanks so much,
Carol
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Evan Rempel [EMAIL PROTECTED]
Senior Progra
is
some that is more explicit than what I quoted above.
Thanks so much,
Carol
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Evan Rempel [EMAIL PROTECTED]
Senior Progra
result is a mostly static
footprint with regards to disk space used, but I would like to
know how much room is usable inside the tables as well as the
OS file system (that part is easy).
--
Evan Rempel
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your
Our experience shows that the 2.5 inch 10K disks have about the same
I/O rate as the 3.5 inch 15K disks. Ideal would be 15K 2.5 inch.
To answer you bigger question, it depends on how many threads are
running to perform the inserts. If you have lots (2-3 times as many threads
as disks) then your I
comment on this functionality of PgPool-II or on this
approach to failover in general?
Evan Rempel.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
, although not impossible, to get a program to do this.
Evan Rempel.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Technically it can be done, but just because we can do something does not
mean we should do something. Having said that...
We have been using a middleware product that shall remain nameless,
that goes against a large commercial database that shall also remain nameless.
The middleware has been mig
.
There is of course a small window though where you are not protected.
Brad.
--
Evan Rempel erem...@uvic.ca
Senior Systems Administrator 250.721.7691
Unix Services, University Systems, University of Victoria
--
Sent via pgsql-admin mailing
14 matches
Mail list logo