Hello Sir/Madam,
I have one query regarding client/server authentication using certificate
in postgres.
I am able to establish client server connection with OpenSSL certificate
creation.
We can create server and root certificates using OpenSSL and keep them in
data directory.
We need to update f
Originally posted in the Admin list but trying here to get more eyes on
it :-)
Greetings admins!
I found that the ignore_system_indexes flag apparently doesn't get me
past this case of a corrupt index as seen below.
Or am I doing something silly here?
The particular DB is a scratch so we'
Greetings,
* Meera Nair (mn...@commvault.com) wrote:
> The backups we ran were all exclusive backups.
You should not use exclusive backups. They've been deprecated for a
long, long time and have been removed in the most recent version of PG.
You really should not be trying to build your own too
Hello,
I was doing some experimenting to try and reduce the execution time of a query
used in a PreparedStatement. To do that, I normally use the Prepare and Execute
statements of Postgresql. What I notice is that explicit casting has a
considerable performance impact. So using the good data ty
Hi Stephen,
The backups we ran were all exclusive backups.
pg_start_backup('label') returned 000400020041. Then we made a copy
of data directory .
Then pg_stop_backup() was executed and it returned 000400020046.
After this 2 databases were dropped and recreated (u
