Re: Command prompt window (8.0)

Vernon wrote:
> Just installed the 8.0 version for Windows. As a Unix
> guy, I would like to do things through the command
> prompt. I have trouble to bring up it. After bringing
> up the "psql to template1" as the same user of the
> installation configuration, it disappears right after
> I type in the password, which is the same outcome with
> a different user.
>
> How to bring up the command prompt correctly?

I think you are selecting "psql to template1" from the menus installed
by the MSI installer for the Windows version of PG, correct?  If so,
that command will attempt to connect to the template1 database running
locally on your Windows box.  Make sure that the Windows service for
that database is running before attempting to connect.  Use the "start
service" menu item.  Better yet, open up the Windows "Services"
management console so you can make sure that service really starts.

Then, rather than use the menu item to connect to the database, open up
a Windows console window yourself, switch to the PG installation
directory /bin, and run

psql -U userid -d dbname -h hostname

With suitable substitutions.  This way, if/when the connection fails,
you should be able to see some kind of diagnostic message as to why it
failed.

>
> Thanks,
>
> Vernon
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq



--
Guy Rouillier