[ale] PostgreSQL DBA Guides

Jim Kinney jim.kinney at gmail.com
Thu Sep 22 12:17:05 EDT 2011


Super cool use of pgadmin: run gui local an tunnel over ssh to db machine!
Set up ssh tunnel from local port 5432 to remote 5432 and connect to server
localhost.
If you use ssl connection to remote db local gui can handle rhat as well.
Lastly (for a good reason) postgresql can be configured to accept
connections from defined IP address and user/pw combinations directly.
On Sep 22, 2011 11:04 AM, "Jim Lynch" <ale_nospam at fayettedigital.com> wrote:
> On 09/20/2011 11:45 AM, Jim Lynch wrote:
>> Like David, I have only used PostgreSQL when some other package required
>> it and configured it. So I decided I'd take it for a test drive. I'm
>> fond of PhpMySql so I installed the equivalent for PostgreSQL. It just
>> doesn't work on Ubuntu 10.04. I'm thinking PostgreSQL and associated
>> programs aren't quite mature enough to use. I'll stick to MySql for
>> now, thanks.
>>
>> Jim.
>>
> OK, I'll admit that wasn't quite fair. I do have a couple of systems
> that I can't run GUIs on so I have to use a web based tool. They are
> located too far away to make an ssh tunnel practical. Latency is baaaad.
>
> I did run the GUI locally and it is quite nice. I'll probably get
> around to testing PostgreSQL on my next project, if it stays local.
>
> Thanks for pointing out the error in my ways. ;)
>
> Jim.
>
> Jim.
>
>
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.ale.org/pipermail/ale/attachments/20110922/54669970/attachment.html 


More information about the Ale mailing list