Cant start PostgreSQL Using command prompt

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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&gt;

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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 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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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>wrote:

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

--
Regards
Saravanan.N.
Ph: +91-9965003321
Twitter : twitter.com/#!/Saravanan221186/<http://twitter.com/#%21/Saravanan221186/&gt;

"First, be unique. Second, remember that 21st century India requires you to
‘work with integrity and succeed with integrity’. Third, the spirit of
‘What Can I Give’ shall replace the attitude of ‘What Can I Take’ — which
is what causes greed, leading to problems like corruption, environmental
degradation and moral turpitude." - Dr.A.P.J.Abdul Kalam