Обсуждение: Cant start PostgreSQL Using command prompt
Hi, I am using PostgreSQL. If am starting the db with System Account/ any domain account using wrapper, the DB is starting fine. If i am trying to start the PostgreSQL DB using command prompt, [Normal mode or Run as administrator.], It wont start. I provided full permission for everyone in Postgres DB Folder. I didn't find any error in pg_log file. I installed DB in 2008 R2 windows machine. My command : *pg_ctl -D "..\data" -o -p3306 --log "D:\logs\pglog.txt" start &* * * Thanks in advance. -- Regards Saravanan.N.
On Wed, Sep 11, 2013 at 4:00 AM, Saravanan Nagarajan <n.saravanan86@gmail.com> wrote: > Hi, > > I am using PostgreSQL. If am starting the db with System Account/ any domain > account using wrapper, the DB is starting fine. > > If i am trying to start the PostgreSQL DB using command prompt, [Normal mode > or Run as administrator.], It wont start. I provided full permission for > everyone in Postgres DB Folder. > > I didn't find any error in pg_log file. I installed DB in 2008 R2 windows > machine. > > My command : pg_ctl -D "..\data" -o -p3306 --log "D:\logs\pglog.txt" start & What is exactly the version of Postgres you are trying to use? What is the output of D:\logs\pglog.txt? -- Michael
On 9/11/2013 4:00 AM, Saravanan Nagarajan wrote: > I am using PostgreSQL. If am starting the db with System Account/ any > domain account using wrapper, the DB is starting fine. > > If i am trying to start the PostgreSQL DB using command prompt, > [Normal mode or Run as administrator.], It wont start. I provided full > permission for everyone in Postgres DB Folder. > > I didn't find any error in pg_log file. I installed DB in 2008 R2 > windows machine. > > My command : *pg_ctl -D "..\data" -o -p3306 --log "D:\logs\pglog.txt" > start &* > * > * NET START "postgres service name" btw, afaik Windows command prompt has no idea what & means. -- john r pierce 37N 122W somewhere on the middle of the left coast
John R Pierce, 11.09.2013 19:19: > btw, afaik Windows command prompt has no idea what & means. No, that's not true. See here for example: <http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/ntcmds_shelloverview.mspx?mfr=true>
In pglog_txt, LOG: could not bind IPv6 socket: No error HINT: Is another postmaster already running on port 33307? If not, wait a few seconds and retry. LOG: could not bind IPv4 socket: No error HINT: Is another postmaster already running on port 33307? If not, wait a few seconds and retry. WARNING: could not create listen socket for "localhost" FATAL: could not create any TCP/IP sockets But already, i set ipv6&4 in pg_hba.conf file. My PostgreSQL Version : 9.2.1 -- Saravanan . On 11 September 2013 18:31, Michael Paquier <michael.paquier@gmail.com>wrote: > On Wed, Sep 11, 2013 at 4:00 AM, Saravanan Nagarajan > <n.saravanan86@gmail.com> wrote: > > Hi, > > > > I am using PostgreSQL. If am starting the db with System Account/ any > domain > > account using wrapper, the DB is starting fine. > > > > If i am trying to start the PostgreSQL DB using command prompt, [Normal > mode > > or Run as administrator.], It wont start. I provided full permission for > > everyone in Postgres DB Folder. > > > > I didn't find any error in pg_log file. I installed DB in 2008 R2 windows > > machine. > > > > My command : pg_ctl -D "..\data" -o -p3306 --log "D:\logs\pglog.txt" > start & > What is exactly the version of Postgres you are trying to use? > What is the output of D:\logs\pglog.txt? > -- > Michael >
On Tue, Sep 17, 2013 at 1:52 AM, Saravanan Nagarajan <n.saravanan86@gmail.com> wrote: > In pglog_txt, > > LOG: could not bind IPv6 socket: No error > HINT: Is another postmaster already running on port 33307? If not, wait a > few seconds and retry. > LOG: could not bind IPv4 socket: No error > HINT: Is another postmaster already running on port 33307? If not, wait a > few seconds and retry. > WARNING: could not create listen socket for "localhost" > FATAL: could not create any TCP/IP sockets > > But already, i set ipv6&4 in pg_hba.conf file. > My PostgreSQL Version : 9.2.1 This might be caused by something that changed on your Windows environment like the addition of a new software (Anti-virus)? Also, are you sure that your server is not running? Is there any process Postgres.exe listed if you run a simple command tasklist? -- Michael
Hi Michael & Team, No anti-virus is running on that machine. I started the DB using Windows service. Its working fine. I am trying to start the DB with different user credentials using command prompt, the DB is not started. I provided full permission for everyone to postgres folder and its sub folder. On 19 September 2013 13:00, Michael Paquier <michael.paquier@gmail.com>wrot= e: > On Tue, Sep 17, 2013 at 1:52 AM, Saravanan Nagarajan > <n.saravanan86@gmail.com> wrote: > > In pglog_txt, > > > > LOG: could not bind IPv6 socket: No error > > HINT: Is another postmaster already running on port 33307? If not, wai= t > a > > few seconds and retry. > > LOG: could not bind IPv4 socket: No error > > HINT: Is another postmaster already running on port 33307? If not, wai= t > a > > few seconds and retry. > > WARNING: could not create listen socket for "localhost" > > FATAL: could not create any TCP/IP sockets > > > > But already, i set ipv6&4 in pg_hba.conf file. > > My PostgreSQL Version : 9.2.1 > This might be caused by something that changed on your Windows > environment like the addition of a new software (Anti-virus)? Also, > are you sure that your server is not running? Is there any process > Postgres.exe listed if you run a simple command tasklist? > -- > Michael > --=20 Regards Saravanan.N. Ph: +91-9965003321 Twitter : twitter.com/#!/Saravanan221186/<http://twitter.com/#%21/Saravan= an221186/> "First, be unique. Second, remember that 21st century India requires you to =91work with integrity and succeed with integrity=92. Third, the spirit of =91What Can I Give=92 shall replace the attitude of =91What Can I Take=92 = =97 which is what causes greed, leading to problems like corruption, environmental degradation and moral turpitude." - Dr.A.P.J.Abdul Kalam