Skip site navigation (1) Skip section navigation (2)

Re: Postgresql

From: Jason Tishler <jason(at)tishler(dot)net>
To: zamie zamie <zamie80(at)yahoo(dot)com>
Cc: Pgsql-Cygwin <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: Postgresql
Date: 2004-10-27 12:05:10
Message-ID: 20041027120510.GA1708@tishler.net (view raw or flat)
Thread:
Lists: pgsql-cygwin
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

pgsql-cygwin by date

Next:From: Reini UrbanDate: 2004-10-27 12:30:26
Subject: contrib/tsearch2 missing LIBS
Previous:From: M SDate: 2004-10-26 21:21:43
Subject: Login failure : Error 1069

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group