Thread: Starting the Database

Starting the Database

From
Vyom A
Date:
Hi all,
 
I have tried a lot to search info available on Google, but still I have trouble!, I have installed the 8.0.2 version on Win2000,
I have installed as a program (not as service)
I am not able to start the database, first I was getting the error "cannot run as admin ...", so I tried to use the "runas",
I copied the properties of the shortcut from the Start-programs->PostgreSQL->start database
then I used
 
runas  /user:vyom "D:\Program Files\PostgreSQL\8.0\bin\pg_ctl.exe  start -D D:\Program Files\PostgreSQL\8.0\data\"
 
message is printed like ..."starting as user vyom..."
 
But nothing happens, no messages, database not started!
Please help.


Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.

Re: Starting the Database

From
Vyom A
Date:
I tried those options, a DOS window suddenly appears and disappers, I cant even see what are the error messages, but still the database not starting!
Any other way to check the problem?

operationsengineer1@yahoo.com wrote:
> runas /user:vyom "D:\Program
> Files\PostgreSQL\8.0\bin\pg_ctl.exe start -D
> D:\Program Files\PostgreSQL\8.0\data\"
>
> message is printed like ..."starting as user
> vyom..."
>
> But nothing happens, no messages, database not
> started!
> Please help.

my cygwin based start up script is

pg_ctl start -D /usr/share/postgresql/data -o -i

you may be able to apply this to your circumstance
with pg 8.

keep in mind - that "-o -i" is important - my db
doesn't work right without those parameters.

i hope this helps.


Yahoo! Mail
Stay connected, organized, and protected. Take the tour

Re: Starting the Database

From
John DeSoi
Date:
On May 13, 2005, at 1:27 AM, Vyom A wrote:

> I tried those options, a DOS window suddenly appears and disappers, I
> cant even see what are the error messages, but still the database not
> starting!
> Any other way to check the problem?


Include the logfile option (-l) in the parameters to pg_ctl. The
logfile should tell you why the server is not starting.


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


Re: Starting the Database

From
Vyom A
Date:
I tried this also, but nothing is logged (the file is not created at all)
 
The command is as follows:
D:\Program Files\PostgreSQL\8.0\bin>runas /user:vyom "pg_ctl.exe -l D:\pglog.
txt start -D D:\data"
Enter password for vyom:
Attempting to start "pg_ctl.exe -l D:\pglog.txt start -D D:\data" as user "vyom"...
 
Then a window comes and disappears, how can I make out what is happening?

John DeSoi <desoi@pgedit.com> wrote:

On May 13, 2005, at 1:27 AM, Vyom A wrote:

> I tried those options, a DOS window suddenly appears and disappers, I
> cant even see what are the error messages, but still the database not
> starting!
> Any other way to check the problem?


Include the logfile option (-l) in the parameters to pg_ctl. The
logfile should tell you why the server is not starting.


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


Yahoo! Mail
Stay connected, organized, and protected. Take the tour

Re: Starting the Database

From
John DeSoi
Date:
On May 14, 2005, at 5:36 AM, Vyom A wrote:

>
> The command is as follows:
> D:\Program Files\PostgreSQL\8.0\bin>runas /user:vyom "pg_ctl.exe -l
> D:\pglog.
> txt start -D D:\data"
> Enter password for vyom:
> Attempting to start "pg_ctl.exe -l D:\pglog.txt start -D D:\data" as
> user "vyom"...
>  
> Then a window comes and disappears, how can I make out what is
> happening?


Can you login as the runas user and leave that out of the command? This
would hopefully avoid starting a new shell so you could see what the
output is.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


Re: Starting the Database

From
Vyom A
Date:

Unfortunately, I am doing the same  :( ................
 
i.e I am logging as "vyom" to my machine. the login has no admin previlages!, but PostGre says that it has!
So I tried to use "runas" with "/user:vyom" ......
Will creating another temporary user-ID and re-logging work?


John DeSoi <desoi@pgedit.com> wrote:

On May 14, 2005, at 5:36 AM, Vyom A wrote:

>
> The command is as follows:
> D:\Program Files\PostgreSQL\8.0\bin>runas /user:vyom "pg_ctl.exe -l
> D:\pglog.
> txt start -D D:\data"
> Enter password for vyom:
> Attempting to start "pg_ctl.exe -l D:\pglog.txt start -D D:\data" as
> user "vyom"...
>  
> Then a window comes and disappears, how can I make out what is
> happening?


Can you login as the runas user and leave that out of the command? This
would hopefully avoid starting a new shell so you could see what the
output is.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


Do you Yahoo!?
Make Yahoo! your home page

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