Re: Postgresql

Zam,

Please post instead of sending private email.

On Wed, Oct 27, 2004 at 12:50:53AM -0700, zamie zamie wrote:
> i'm trying to install postgresql on window 2000 for the first time. I
> followed the README file and the response i got are as follows:
>
> $ postmaster -D/usr/share/postgresql/data
> LOG:  database system was interrupted at 2004-10-27 15:34:22 MPST
> LOG:  checkpoint record is at 0/83B338
> LOG:  redo record is at 0/83B338; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction id: 480; next oid: 16976
> LOG:  database system was not properly shut down; automatic recovery
> in progress
> LOG:  ReadRecord: record with zero length at 0/83B378
> LOG:  redo is not required
> LOG:  database system is ready
>
> no $ sign appears after that.

The above is correct and expected behavior.

> but according to the manual i still have to type one more line which
> is
>
> 4. Connect to PostgreSQL:
> $ psql template1
>
> how do i go about it.Is there something wrong with my installation?
> And how to view the database. As we can view mysql database through
> phpmyadmin, so how can i view postgresql  database.

Just open another (bash) window and run the psql command.

> Please guide. Sorry for any inconvenience. Your help is very much
> appreaciated.

You are quite welcome.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6