SOLUTION: it turns out the ORDER of iptables matters. The firth INPUT rule is REJECT all ... which precludes the ACCEPT rule. So I had to use iptables -I INPUT 5 ... to add the rule in the fifth ...
I run Postgresql 8.4 as a service on a CentOS 6.2 server. I set port = 21444 and listen_addresses = '*' in /var/lib/pgsql/data/postgresql.conf and I changed 5432 to 21444 in postmaster.opts and ...
I'm using Pear MDB2 to connect my postgresql base. dsn variable looks like user:pass@host/base_name I have such an error: MDB2 Error: connect failed, _doConnect: [Error message: unable to establish ...
I'm trying to upgrade PostgreSQL 8.3 to 8.4 using Ports on FreeBSD (7.2). I found a few good guides, such as this one, but they won't work. Upon running 'portupgrade -o databases/postgresql84-client ...
I know that by default PostgreSQL listens on port 5432, but what is the command to actually determine PostgreSQL's port? Configuration: Ubuntu 9.10 with PostgreSQL 8.4
I want to give remote access to my postresql db (8.2) to computers that are at the same lan, at the default config I have added this line to pg_hba.conf where xxx.xx.xx.xx is the ip of the machine ...