Thread: Starting the Database
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.
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
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
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"...
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
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
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