On Thu, Jul 01, 2004 at 09:25:29AM -0600, Scott Marlowe wrote:
> > > > Yes, the following lines appear uncommented in my
> > > > /etc/postgresql/postgresql.conf:
> > > >
> > > > tcpip_socket = true
> > > > port = 5432
> > > >
> > > > But then:
> > > >
> > > > [EMAIL PROTECTED]:~# netstat -auntp
> > > >
> > > > shows postmaster running on a udp port???
> > > >
> > > > udp 0 0 127.0.0.1:1042 127.0.0.1:1042
> > > > ESTABLISHED18375/postmaster
> > > >
> > >
> > > But can you nmap it? And that's not the right default port 5432...
> > > Maybe it's some new feature I'm familiar with, or you've changed it.
> >
> > Trust me, I am a postgres newbie... I'm not trying to do anything but a *very*
> > ordinary install!
>
> Well, something is quite wrong then. Find your postgresql.conf file and
> see what port it is set to there. port 1042 is definitely not the
> default port.
>
> Also, try two things:
>
> nmap -p 1042
> psql -h 127.0.0.1 -p 1042
>
[EMAIL PROTECTED]:~# nmap -p 1042
Starting nmap 3.50 ( http://www.insecure.org/nmap/ ) at 2004-07-02 12:36 EST
WARNING: No targets were specified, so 0 hosts scanned.
Nmap run completed -- 0 IP addresses (0 hosts up) scanned in 0.003 seconds
[EMAIL PROTECTED]:~# psql -h 127.0.0.1 -p 1042
No database specified
[EMAIL PROTECTED]:~#
*sigh*
I am beginning to think this is probably a build issue with the user mode linux
kernel I'm using. I'll look into that now.
Thanks,
Jens
> If nmap can see the port open, and psql can open it, then you can just
> use it like that by specifying that port each time in your connect
> string.
>
> > >
> > > What does nmap <ip> show?
> >
> > [EMAIL PROTECTED]:~# nmap localhost
> >
> > Starting nmap 3.50 ( http://www.insecure.org/nmap/ ) at 2004-07-01 15:39 EST
> > Interesting ports on localhost (127.0.0.1):
> > (The 1654 ports scanned but not shown below are in state: closed)
> > PORT STATE SERVICE
> > 22/tcp open ssh
> > 25/tcp open smtp
> > 80/tcp open http
> > 113/tcp open auth
> > 515/tcp open printer
> >
> > Nmap run completed -- 1 IP address (1 host up) scanned in 1.735 seconds
> > [EMAIL PROTECTED]:~#
> >
> > > > A server restart shows:
> > > >
> > > > [EMAIL PROTECTED]:~# /etc/init.d/postgresql restart
> > > > Stopping PostgreSQL database server: autovacuumNo pg_autovacuum found
> > > > running;
> > > > none killed.
> > > > postmaster.
> > > > Starting PostgreSQL database server: postmaster autovacuum.
> > >
> > > Sounds like a firewall to me.
> > >
> > My colleague here at work who built the user mode linux image I'm using
> > (the virtual "box") assures me there's no firewall installed.... how
> > would I check if there were?
>
> IF the database is configured for port 1042, then it might not be a
> firewall, just a misconfiguration of the database.
>
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
