"Daniel Ricardo Medina" <[EMAIL PROTECTED]> writes:
> I have try to run this command in single user mod
>
> select * from pg_shadow;
> delete from pg_shadow;
> CREATE USER postgres WITH CREATEDB CREATEUSER PASSWORD '***' SYSID 1;
> CREATE USER userradar PASSWORD '***'
> but the result is the s
I saw something along these lines recently when I was running stuff from
postgres 7.4.7 (we recently upgraded to 8.2.3). Basically, a unique index
somehow fails and allows duplicate rows...but I don't know why.
Deleting doesn't work because postgres only looks for the record shown by
the index (t
Warren Little <[EMAIL PROTECTED]> writes:
> I'm testing my PITR recovery procedures and something doesn't look
> right.
> The following is from the logs upon starting postgres with
> recovery.conf file in place
> @ 2007-03-23 05:57:33 MDTLOG: restored log file
> "0001011A00FD" f
Ray Stell <[EMAIL PROTECTED]> writes:
> On Fri, Mar 23, 2007 at 06:01:17PM -0400, Tom Lane wrote:
>> Ray Stell <[EMAIL PROTECTED]> writes:
>>> I was hoping to not have to support client certs. I want
>>> encryption and to verify the server, but no to verify the client.
>>> Does this work and I've
On Sun, Mar 25, 2007 at 10:01:20PM -0400, Tom Lane wrote:
> I looked more closely and you are right: if the server does not have
> a root.crt file then it doesn't send its server cert to the client,
> and so there's no way for the client to verify the cert.
Eh? ssldump shows otherwise here with 8
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Sun, Mar 25, 2007 at 10:01:20PM -0400, Tom Lane wrote:
>> I looked more closely and you are right: if the server does not have
>> a root.crt file then it doesn't send its server cert to the client,
>> and so there's no way for the client to verify the c
On Mon, Mar 26, 2007 at 12:04:21AM -0400, Tom Lane wrote:
> Well, if it works then why is the OP complaining?
>
> Perhaps there is some non-obvious configuration issue that accounts
> for the difference between your results and his?
I don't see in the OP's messages that he's tried the configurati
