[BUGS] BUG #3736: server cannot listen
The following bug has been logged online: Bug reference: 3736 Logged by: Derek Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.10 Operating system: Windows XP Professional Description:server cannot listen Details: when i try to connect to the postgreSQL database i get this error message: Server doesn't listen The server doesn't accept connections: the connection library reports could not connect to server: Connection refused (0x274D/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? If you encounter this message, please check if the server you're trying to contact is actually running PostgreSQL on the given port. Test if you have network connectivity from your client to the server host using ping or equivalent tools. Is your network / VPN / SSH tunnel / firewall configured correctly? For security reasons, PostgreSQL does not listen on all available IP addresses on the server machine initially. In order to access the server over the network, you need to enable listening on the address first. For PostgreSQL servers starting with version 8.0, this is controlled using the "listen_addresses" parameter in the postgresql.conf file. Here, you can enter a list of IP addresses the server should listen on, or simply use '*' to listen on all available IP addresses. For earlier servers (Version 7.3 or 7.4), you'll need to set the "tcpip_socket" parameter to 'true'. You can use the postgresql.conf editor that is built into pgAdmin III to edit the postgresql.conf configuration file. After changing this file, you need to restart the server process to make the setting effective. If you double-checked your configuration but still get this error message, it's still unlikely that you encounter a fatal PostgreSQL misbehaviour. You probably have some low level network connectivity problems (e.g. firewall configuration). Please check this thoroughly before reporting a bug to the PostgreSQL community. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[BUGS] BUG #4369: connectby method
The following bug has been logged online: Bug reference: 4369 Logged by: Derek & Bob Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 Operating system: Linux Description:connectby method Details: I've got a question about table connectby method. Say, we have five elements which are 1,2,3,4,5. Each of them are the roots in the tree.Instead of using five connectby methods to generate them all in the table, I assume there is a element 0, which is the parent of them, in the tree(which is not existed in the real table). So only one connectby is enough to get them all, and it works. I don't know whether it's a bug or it's ok. Thanks. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #4370: connectby method
The following bug has been logged online: Bug reference: 4370 Logged by: Derek & Bob Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 Operating system: Linux Description:connectby method Details: I've got a question about table connectby method. Say, we have five elements which are 1,2,3,4,5. Each of them are the roots in the tree.Instead of using five connectby methods to generate them all in the table, I assume there is a element 0, which is the parent of them, in the tree(which is not existed in the real table). So only one connectby is enough to get them all, and it works. I don't know whether it's a bug or it's ok. Thanks. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #3726: Unable to upgrade
The following bug has been logged online: Bug reference: 3726 Logged by: Derek G Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.1 Operating system: WinXP Description:Unable to upgrade Details: Since installing v8.2.1 I have been unable to upgrade to later versions. When running update.bat, it gives an error message towards the end of the installation stating "please verify you have administrative privileges." I do use an administrator account and all my AV/Spyware/Firewall/etc. are shut off prior to installation. Nothing I do allows the update to finish. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[BUGS] BUG #4175: PostgreSQL Service starts, then stops automatically
The following bug has been logged online: Bug reference: 4175 Logged by: derek hopkins Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.2.1 Operating system: Windows XP Description:PostgreSQL Service starts, then stops automatically Details: when trying to connect to PostgreSQL through PGAdminIII i get ...connection fails. When i go into the services and try to start it from there i get a Windows message stating 'The PostgreSQL Database Server 8.1 service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service.' -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
