Re: [ADMIN] newer release branch

2010-10-07 Thread Scott Marlowe
2010/10/6 Devrim GÜNDÜZ : > On Wed, 2010-10-06 at 16:02 -0600, Scott Marlowe wrote: > >> > 9.0 can be installed in parallel with yum, however still a >> > dump/restore or replication/failover type thing is needed, since 8.1 >> > is not supported by pg_upgrade. >> >> Really?  I've gotten apt based s

Re: [ADMIN] query execution time

2010-10-07 Thread Julius Tuskenis
2010.10.06 17:03, Kevin Grittner rašė: Version string: PostgreSQL 8.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 (Gentoo 4.1.2 p1.0.2) https://sites.google.com/site/juliaustestukas/Home Well, you're showing us a version string for a Linux PostgreSQL server, but you link to a scr

[ADMIN] installation failed for PostgreSQL 9.0.0 in Windows (Visual C++ Runtime Installation error)

2010-10-07 Thread Kiswono Prayogo
Error: Visual C++ Runtime Installation error and installation not continued (i forgot the exact error phrase, i'm using linux right now) PostgreSQL: 9.0.0 OS: Windows XP SP3 Notes: 1. i believe Visual C++ 2005 and 2008 Runtime already installed before 2. im using sing administrator Account 3. m

Re: [ADMIN] query execution time

2010-10-07 Thread Kevin Grittner
Julius Tuskenis wrote: > we connect to localhost on windows machine because we > use ssh tunel to the postgresql server on gentoo linux. Latency in the extra hop or from encryption/decryption of the streams could account for at least some of the difference between how long it took the server

[ADMIN] 5 pg_toast_temp and pg_temp schemas ?

2010-10-07 Thread Andreas
Hi, I just recently activated the system objects in pgAdmin. Now I'm wondering if it's normal to have 5 pg_toast_temp and 5 pg_temp schemas. It's a PG 8.4.0 server of the OpenSuse distribution that works pretty well. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make c

[ADMIN] Monitoring Software

2010-10-07 Thread Samuel Stearns
Howdy, Environment: Postgres 8.3.1 Solaris 10 We are looking at installing a good all-around GUI based monitoring software. We are particularly interested in vacuum stats. Could someone please advise what a good option would be? Thank you, Sam

[ADMIN] PostgreSQL client-server configuration

2010-10-07 Thread amjad usman
Dear All, I am new to postgresql. i want to install postgresql in client-server architecture. can anybody tell me how i can do that? or if i have joined the wrong mailing list, then pliz tell me the correct mailing list where people share their problems regarding postgresql installation and con

Re: [ADMIN] PostgreSQL client-server configuration

2010-10-07 Thread Vladimir Rusinov
On Fri, Oct 8, 2010 at 10:35 AM, amjad usman wrote: > Dear All, > I am new to postgresql. i want to install postgresql in client-server > architecture. > can anybody tell me how i can do that? > PostgreSQL is already uses client-server architecture. Just follow install docs for your OS. or if i