Re: pgAccess via ssh?

mike, i have my development db on my actual laptop. however, the pgadmin "login" screen asked for some input... i recall inputting "localhost", "5432" and maybe some other information (actually, this info was defaulted). I'd bet you can configure it so that it did recognize your linux box. maybe "localhost" would have to be changed to the name of your linux box.

i have some some test sql statements that i could e-mail you should you want to peruse them and see if you can figure them out. you can input them into pgadmin (probably pgaccess, but i don't know) and create some tables and then query them.

i'm not sure what all this ssh stuff is about, though. i haven't had to learn about it yet.

Mike <1100100(at)gmail(dot)com> wrote:
Hi Op,

Thanks for your response.
Were you able to use it remotely from a winbox like I am trying to do?
And you were using it to connect to your db by ssh too?

Tell me more.......I want to try this ASAP.

Thanks for the guidance.

Mike

----- Original Message -----
From: operationsengineer1(at)yahoo(dot)com
Date: Thu, 2 Sep 2004 08:41:54 -0700 (PDT)
Subject: Re: [NOVICE] pgAccess via ssh?
To: Mike <1100100(at)gmail(dot)com>, hbhanujan(at)sbcglobal(dot)net
Cc: pgsql-novice(at)postgresql(dot)org

mike,

fwiw, pgadmin worked well for me and was very easy to set up once i
put the "-i" flag in my postmaster call. never tried pgaccess so
can't comment.

Mike <1100100(at)gmail(dot)com> wrote:

Hi Hari,

Yes, I have been using ssh and bash shell to access my postgres
database using psql -d mydatabase.

Now I'd like to try a Gui frontend to aid the learning process and
help visualize some aspects of building sql queries, etc.

I was going to try pgAccess first because it appears to be a very
small, easy to use app. Maybe later on I would try pgAdmin.

Mike

On Thu, 2 Sep 2004 10:36:24 -0500, Hari Bhanujan
wrote:
> I know that after ssh you can use psql without any problems.
>
> What are you using for postgresql - pgadmin..
>

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

________________________________
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com