On Sat, Oct 9, 2010 at 10:04 PM, Darren Duncan wrote:
> The owner of these new files needs to be the same as that of your Pg data
> dir in general or postgresql.conf specifically, and that owner be the same
> as the process that runs the Pg server. Are you running Pg as root? (In
> any event, yo
Yup, my bad.. I should have noticed all the other files were owned by
postgres (and I assume that's what the process is running under)..
I'm still a Unix newbie, but learning quickly..
Everything's working, and to my surprise pgAdmin connected using SSL
on the first try.. No need to mess with an
The owner of these new files needs to be the same as that of your Pg data dir in
general or postgresql.conf specifically, and that owner be the same as the
process that runs the Pg server. Are you running Pg as root? (In any event,
you should have another user; running programs or servers as r
Sweet! That fixed it.. Rock on..
Of course now let's see if I can connect from my Mac client :)
On Sat, Oct 9, 2010 at 9:00 PM, Ben Carbery wrote:
> The private keys needs to be readable by the same user the server runs
> under. This is distribution-dependent and may not be 'root'.
> In my cas
The private keys needs to be readable by the same user the server runs
under. This is distribution-dependent and may not be 'root'.
In my case I run Red Hat which uses the 'postgres' user, so:
chown postgres.postgres /var/lib/pgsql/data/server.*
On Sun, Oct 10, 2010 at 2:52 PM, Mike Christensen
Hi, I'm trying to require SSL for Postgres connections from certain
IPs.. This is on Postgres 9.0.
First, I've followed the directions at:
http://www.postgresql.org/docs/9.0/static/ssl-tcp.html
I've created the files server.crt and server.key. I've also removed
the passphrase from the key so P
On Sat, Oct 9, 2010 at 5:45 PM, Ben Carbery wrote:
>
>> Or that OP has a networking issue. Some firewalls are known for
>> dropping what they think are idle connections when they aren't.
>>
>
> I don't think so.. EOF is an explicit termination, not a timeout as would
> caused by a firewall droppi
> Or that OP has a networking issue. Some firewalls are known for
> dropping what they think are idle connections when they aren't.
>
>
I don't think so.. EOF is an explicit termination, not a timeout as would
caused by a firewall dropping traffic. It's more like what happens when the
remote proce
On Sat, Oct 9, 2010 at 11:19 AM, Lincoln Yeoh wrote:
> At 11:32 AM 10/9/2010, Craig Ringer wrote:
>>
>> On 10/09/2010 05:30 AM, Carlos Mennens wrote:
>>>
>>> I know that MySQL uses MyISAM storage engine by default and was just
>>> trying to look on Google to try and see if I could understand what
At 11:32 AM 10/9/2010, Craig Ringer wrote:
On 10/09/2010 05:30 AM, Carlos Mennens wrote:
I know that MySQL uses MyISAM storage engine by default and was just
trying to look on Google to try and see if I could understand what
storage engine does PostgreSQL use by default when I generate a
databas
Depending on the significance of the primary key, another option may have
been simply a unique constraint (b,c) on the table before the data was added
On Fri, Oct 8, 2010 at 9:55 PM, A B wrote:
> Thank you all for your replies.
>
>
> 2010/10/8 Alban Hertroys :
> > On 8 Oct 2010, at 8:59, A B wro
11 matches
Mail list logo
