Re: [ADMIN] LONDISTE SKYTOOLS MODULE RPM NOT AVAILABLE FOR POSTGRES-9.0 VERSION

On Mar 5, 2011, at 3:29 AM, Prabhjot S. Sheena wrote: > skytools-90-2.1.11-1.rhel5.x86_64 http://yum.pgrpms.org/9.0/redhat/rhel-5-x86_64/ http://pgfoundry.org/frs/download.php/2872/skytools-2.1.12.tar.gz Thanks & Regards, Vibhor Kumar vibhor@gmail.com Blog:http://vibhork.blogspot.com --

[ADMIN] Postgres native geometry types

Hi Everybody, I am doing some testing on the postgres native geometry types, namely: point, line, lseg, box, path (closed), path [open], polygon and circle. Does anyone know what are they being used for? PostGIS is usually designated as the gis "module" to postgres and there are other spatial t

[ADMIN] LONDISTE SKYTOOLS MODULE RPM NOT AVAILABLE FOR POSTGRES-9.0 VERSION

I AM TRYING TO INSTALL LONDISTE THROUGH RPMS FOR MY POSTGRES-9.0 VERSION. BUT IN THE POSTGRES 9.0 RPM LIST THERE IS ONLY ONE RPM AVAILABLE IE skytools-90-2.1.11-1.rhel5.x86_64 AND THE OTHER ONE IE skytools-mod

[ADMIN] psql causing a error

All of a sudden the psql for 9.0 is giving me the error below. The dump is just a partial dump. Is this a known issue? It was working for about 4 days after I installed the software until around lunch time today. I did the install using the current one-click installer provided by EnterpriseD

Re: [ADMIN] How to upgrade PostgreSQL minor releases without a dump/restore?

On Fri, Mar 04, 2011 at 08:37:46AM -0600, Kenneth Marshall wrote: > On Thu, Mar 03, 2011 at 07:43:46PM -0800, Uwe Schroeder wrote: > > > > Did you read the paragraph above? > > > > Install latest version, and restart postmaster. > > > Installing of latest version as-is will keep overwriting the exi

Re: [ADMIN] How to upgrade PostgreSQL minor releases without a dump/restore?

On Thu, Mar 03, 2011 at 07:43:46PM -0800, Uwe Schroeder wrote: > > > > ? Did you read the paragraph above? > > > > > > Install latest version, and restart postmaster. > > > > Installing of latest version as-is will keep overwriting the existing > > installed directories/files/binaries but not th

Re: [ADMIN] Server doesn't listen error

> One more thing can anyone point me to contrib for postgresql 8.2 the > default intalling from ap-get is for 8.4. From where do you have your 8.2 ubuntu package? Or get it from the 8.2 sources. I assume you read http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy ? > 2011/3/4 Lu

Re: [ADMIN] Server doesn't listen error

One more thing can anyone point me to contrib for postgresql 8.2 the default intalling from ap-get is for 8.4. 2011/3/4 Lukasz Brodziak : > Ok, I want to marry Your bones :) it was the firewall but strange > thing is that I managed to get the connection to work with WIndows > remote machine but wi

Re: [ADMIN] Server doesn't listen error

Ok, I want to marry Your bones :) it was the firewall but strange thing is that I managed to get the connection to work with WIndows remote machine but with linux I had to turn off the firewall. 2011/3/4 Lukasz Brodziak : > Hello, > > The ifconfig showed I was wrong about IP address yet still prob

Re: [ADMIN] Server doesn't listen error

Hello, The ifconfig showed I was wrong about IP address yet still problem remains. The output of iptables on Ubuntu: Chain INPUT (policy ACCEPT) target prot opt source destination Chain FORWARD (policy ACCEPT) target prot opt source destination Chain OUTPUT (p

Re: [ADMIN] Server doesn't listen error

> I forgo to tell that client is a Windows machine so the iptables won't > run on it. > But on the server it will. So please post the output of the two commands and make sure that your Windows firewall (if activated) doesn't block outgoing traffic to port 5432. I feel it in my bones it's your Wi

Re: [ADMIN] Server doesn't listen error

I forgo to tell that client is a Windows machine so the iptables won't run on it. 2011/3/4 Frank Brendel : > >> output form psql: >> >> psql: could not connect to server: Connection refused (0x274D/10061) >>          Is the server running on host "10.10.128.145" and accepting >>          TCP/I

Re: [ADMIN] Server doesn't listen error

> output form psql: > > psql: could not connect to server: Connection refused (0x274D/10061) > Is the server running on host "10.10.128.145" and accepting > TCP/IP connections on port 5432? > Ok, seems that the server is up but either it is the wrong IP address or something

Re: [ADMIN] Server doesn't listen error

Hello, output form psql: psql: could not connect to server: Connection refused (0x274D/10061) Is the server running on host "10.10.128.145" and accepting TCP/IP connections on port 5432? 2011/3/4 Frank Brendel : > >> The netstat command output: >> tcp        0      0 0.0.0.0:

Re: [ADMIN] Server doesn't listen error

> The netstat command output: > tcp0 0 0.0.0.0:54320.0.0.0:* > LISTEN 13040/postgres > tcp6 0 0 :::5432 :::* > LISTEN 13040/postgres > Ok, the server is listening. So what is the output of # psql -h E.g. if you can't connect you shou

Re: [ADMIN] Server doesn't listen error

Hi, The netstat command output: tcp0 0 0.0.0.0:54320.0.0.0:* LISTEN 13040/postgres tcp6 0 0 :::5432 :::* LISTEN 13040/postgres 2011/3/4 Frank Brendel : > Hi Łukasz, > > is postgres really listening on all addresses? > > Please run the

Re: [ADMIN] [HACKERS] Re: PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum

On Thu, Mar 03, 2011 at 09:04:04AM -0600, Merlin Moncure wrote: > On Thu, Mar 3, 2011 at 2:16 AM, Heikki Linnakangas > wrote: > > On 03.03.2011 09:12, daveg wrote: > >> > >> Question: what would be the consequence of simply patching out the setting > >> of this flag? Assuming that the incorrect PD

Re: [ADMIN] Server doesn't listen error

On Mar 4, 2011, at 12:23 PM, Lukasz Brodziak wrote: > > I have a problem with PostgreSQL 8.2.4 I've installed it on Ubuntu > configured to listen to all addresses started and still can't add the > server to pgAdmin on a remote machine neither can I connect through my > own app. All the credentia