Re: [BUGS] postgresql 8.2.4 install problem
Hello, On Sat, 2007-05-19 at 13:20 +0100, Pedro Doria Meunier wrote: > When trying to install postgresql 8.2.4 (RPM) on Fedora Core 6 there's > a dependency problem with libpq.so.4 . I *forgot* to upload copy compat packages for 8.2.4. :( Since they are the same as 8.2.3 compat package, please download this package: ftp://ftp-archives.postgresql.org/pub/binary/v8.2.3/linux/rpms/fedora/fedora-core-6/compat-postgresql-libs-4-2PGDG.fc6.i686.rpm Install this package before installing postgresql-libs RPM. I am currently copying compat packages for 8.2.4. They will be available in main FTP site in 1-2 hours. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
[BUGS] BUG #3293: installation failed
The following bug has been logged online: Bug reference: 3293 Logged by: farooq hasny Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: windows xp SP2 Description:installation failed Details: when i run the postgresql-8.2.msi file setup appears but disappears after language selection. task manager shows 3 instances of msiexec.exe if i kill one of them setup appears but ends with error in installation log MSI (c) (F4:40) [11:38:22:562]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2769 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[BUGS] Database Server Remote connection failed
Hi,I can't establish a connection to PostgreSQL(version postgresql-8.2.4) Server. I'am sure what i config is right. Following are what i do to enable remote connection: 1. edit/usr/local/pgsql/data/postgresql.confenable remote tcp/ip connection:listen_addresses = '*'port = 5432max_connection = 100 2. edit/usr/local/pgsql/data/pg_hba.confadd remote client that will connect to the server to pg_hba.conf for example:PC_Server IP: 192.168.1.98 Running PostgreSQL Server. Linux OS.PC_Client IP: 192.168.1.25 Will connect to the PC_Server. Windows XP OS so, i add one line to pg_hba.conf :hostallall 192.168.1.25/32trust---But when i established a connection to the PC_Server on the PC_Client(C:\Program Files\PostgreSQL\8.0.0-rc1\bin>psql -h 192.168.1.98 -U postgres postgres) the system give me one message: psql: could not connect to server: No route to host (0x2751/10065) Is the server running on host "192.168.1.98" and accepting TCP/IP connections on port 5432?-Please tell me why, or whatever i made mistake.Thanks!
Re: [BUGS] Database Server Remote connection failed
Íõ·å wrote: > Hi, > I can't establish a connection to PostgreSQL(version postgresql-8.2.4) > Server. I'am sure what i config is right. > > Following are what i do to enable remote connection: > > 1. edit /usr/local/pgsql/data/postgresql.conf > enable remote tcp/ip connection: > listen_addresses = '*' > port = 5432 > max_connection = 100 > > 2. edit /usr/local/pgsql/data/pg_hba.conf > add remote client that will connect to the server to pg_hba.conf > > for example: > PC_Server IP: 192.168.1.98 Running PostgreSQL Server. Linux OS. > PC_Client IP: 192.168.1.25 Will connect to the PC_Server. Windows XP OS > > so, i add one line to pg_hba.conf : > hostallall192.168.1.25/32trust > --- > But when i established a connection to the PC_Server on the PC_Client > (C:\Program Files\PostgreSQL\8.0.0-rc1\bin>psql -h 192.168.1.98 -U > postgres postgres) 8.0.0-rc1 ??? > > the system give me one message: > psql: could not connect to server: No route to host (0x2751/10065) > Is the server running on host "192.168.1.98" and accepting > TCP/IP connections on port 5432? well "no route to host" is a network level problem - either you client is not connected (physically or logically) to that network at all - your you have a firewall on either the client or the server that is blocking your requests. Stefan ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [BUGS] Database Server Remote connection failed
王峰 wrote: Hi,I can't establish a connection to PostgreSQL(version postgresql-8.2.4) Server. I'am sure what i config is right. Following are what i do to enable remote connection: 1. edit/usr/local/pgsql/data/postgresql.confenable remote tcp/ip connection:listen_addresses = '*'port = 5432max_connection = 100 2. edit/usr/local/pgsql/data/pg_hba.confadd remote client that will connect to the server to pg_hba.conf for example:PC_Server IP: 192.168.1.98 Running PostgreSQL Server. Linux OS.PC_Client IP: 192.168.1.25 Will connect to the PC_Server. Windows XP OS so, i add one line to pg_hba.conf :hostallall192.168.1.25/32 trust---But when i established a connection to the PC_Server on the PC_Client(C:\Program Files\PostgreSQL\8.0.0-rc1\bin>psql -h 192.168.1.98 -U postgres postgres) the system give me one message: psql: could not connect to server: No route to host (0x2751/10065) Is the server running on host "192.168.1.98" and accepting TCP/IP connections on port 5432?-Please tell me why, or whatever i made mistake.Thanks! "No route to host" sounds like a network configuration problem. Make sure you can reach the server from the client with "ping 192.168.1.98". -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[BUGS] BUG #3294: PostgreSQL Setting permissions for folders during installation then Crashing
The following bug has been logged online: Bug reference: 3294 Logged by: Jason Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4-1 Operating system: Windows XP Professional Description:PostgreSQL Setting permissions for folders during installation then Crashing Details: Running the installation, everything works fine until it starts copying files. Then it reaches a fatal error, and says: Failed to set permissions on the installed files. Please see the logfile in 'C:\Program Files\PostgreSQL\8.2\tmp\pgperm.log'. 8.2 then become a folder that I as administrator of the system do not have permissions to access. I can't get into the folder, I can't delete the folder. I can't do anything to it. The installer then rolls back and quits. I've tried this 3 times, and now have 3 different folders that I can't delete. Please help. --Jason ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[BUGS] Fwd: Bug#425125: postgresql-8.1: localhost does not work for unix sockets in ~/.pgpass
Hello PostgreSQL developers, I just got the bug report below from a Debian user. The comment on http://www.postgresql.org/docs/8.1/interactive/libpq-pgpass.html confirms this, it describes the exact same problem. Thank you, Martin - Forwarded message from David <[EMAIL PROTECTED]> - X-Spam-Status: No, score=0.0 required=4.0 tests=BAYES_50,UNPARSEABLE_RELAY autolearn=no version=3.1.7-deb Subject: Bug#425125: postgresql-8.1: localhost does not work for unix sockets in ~/.pgpass Reply-To: David <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Date: Sat, 19 May 2007 12:10:18 +0200 From: David <[EMAIL PROTECTED]> To: Debian Bug Tracking System <[EMAIL PROTECTED]> Package: postgresql-8.1 Version: 8.1.8-1 Severity: normal According to this page: http://www.postgresql.org/docs/8.1/interactive/libpq-pgpass.html "A hostname of localhost matches both host (TCP) and local (Unix domain socket) connections coming from the local machine." However that does not work for me. I get prompted for a password. I have to put '*' in the hostname section to allow passwordless local unix socket connections. eg: Works: *:*:david:david:moo Does not work: localhost:*:david:david:moo -- System Information: Debian Release: lenny/sid APT prefers testing APT policy: (990, 'testing') Architecture: i386 (i686) Kernel: Linux 2.6.18-4-686 (SMP w/1 CPU core) Locale: LANG=en_ZA, LC_CTYPE=en_ZA (charmap=ISO-8859-1) Shell: /bin/sh linked to /bin/bash -- no debconf information - End forwarded message - -- Martin Pitthttp://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [BUGS] Fwd: Bug#425125: postgresql-8.1: localhost does not work for unix sockets in ~/.pgpass
Martin Pitt <[EMAIL PROTECTED]> writes: > I just got the bug report below from a Debian user. The comment on > http://www.postgresql.org/docs/8.1/interactive/libpq-pgpass.html > confirms this, it describes the exact same problem. This seems to be a repeat of http://archives.postgresql.org/pgsql-hackers/2006-05/msg00295.php which was fixed a year ago but only for 8.2 and later, since there was some concern about the change being not backwards compatible. http://archives.postgresql.org/pgsql-committers/2006-05/msg00123.php regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
