Re: [BUGS] Cant start PostgreSQL Using command prompt

2013-09-19 Thread Saravanan Nagarajan 
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 wrote:

> On Tue, Sep 17, 2013 at 1:52 AM, Saravanan Nagarajan
>  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/

"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

Re: [BUGS] Cant start PostgreSQL Using command prompt

2013-09-19 Thread Michael Paquier 
On Tue, Sep 17, 2013 at 1:52 AM, Saravanan Nagarajan
 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

Re: [BUGS] Cant start PostgreSQL Using command prompt

2013-09-17 Thread Saravanan Nagarajan 
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 wrote:

> On Wed, Sep 11, 2013 at 4:00 AM, Saravanan Nagarajan
>  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
>

Re: [BUGS] Cant start PostgreSQL Using command prompt

2013-09-11 Thread Thomas Kellerer 
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:







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

Re: [BUGS] Cant start PostgreSQL Using command prompt

2013-09-11 Thread John R Pierce 

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

Re: [BUGS] Cant start PostgreSQL Using command prompt

2013-09-11 Thread Michael Paquier 
On Wed, Sep 11, 2013 at 4:00 AM, Saravanan Nagarajan
 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

[BUGS] Cant start PostgreSQL Using command prompt

2013-09-11 Thread Saravanan Nagarajan 
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.