Re: [ADMIN] LDAP Authentication

2011-05-21 Thread teguh
I did a test on Ubuntu 11.04, postgreql 9.0.4.1 - 32 bit installer, on non LDAP authenticated desktop. mi@mi-d525:/opt/PostgreSQL/9.0/bin$ ./pg_config --configure '--with-libs=/usr/local/lib' '--with-includes=/usr/local/include' '--prefix=/mnt/buildfarm/pginstaller/server/staging/linux'

[ADMIN] ERROR: could not read block

2011-05-21 Thread Diego Fernández Slezak
Hello everybody, I had a hard drive failure last week. After lots of effort I've been able to backup a 700GB database, with only one file with corruption. When I do some big queries, it throws me errors on this faulty file: could not read block 390041 of relation 1663/350994/351212: read only 0

Re: [ADMIN] visualizing database schema - png/jpeg?

2011-05-21 Thread Wolfgang Keller
Anyone knows of tools that can generate PNG/JPEG image from pgsql database schema? SQLAlchemy allows to generate a graphic of the schema (not only) from PostgreSQL. http://www.sqlalchemy.org/trac/wiki/UsageRecipes/SchemaDisplay Sincerely, Wolfgang -- Sent via pgsql-admin mailing list

Re: [ADMIN] Who is causing all this i/o?

2011-05-21 Thread Tom Lane
Craig James craig_ja...@emolecules.com writes: On 5/20/11 4:25 PM, Scott Marlowe wrote: On Fri, May 20, 2011 at 3:14 PM, Craig Jamescraig_ja...@emolecules.com wrote: Our development server (PG 8.4.4 on Ubuntu server) is constantly doing something, and I can't figure out what. The two

Re: [ADMIN] ERROR: could not read block

2011-05-21 Thread Tom Lane
=?ISO-8859-1?Q?Diego_Fern=E1ndez_Slezak?= dfsle...@gmail.com writes: Hello everybody, I had a hard drive failure last week. After lots of effort I've been able to backup a 700GB database, with only one file with corruption. When I do some big queries, it throws me errors on this faulty file:

[ADMIN] shutdown procedure warm standby

2011-05-21 Thread Syed Khan
Hi, We have a warm standby configuration, what would be a graceful way of shutting down the warm - recovering database on windows for maintenance such as patching. We do it this way... 1. PG_CTL STOP -m FAST but this results in getting this message in the pg_logs once the system and

Re: [ADMIN] visualizing database schema - png/jpeg?

2011-05-21 Thread Turnkey Solutions (Mark Dueck)
might want to take a look at Power*Architect - http://www.sqlpower.ca/page/architect MD On 05/18/2011 01:09 PM, neubyr wrote: Anyone knows of tools that can generate PNG/JPEG image from pgsql database schema? -- neuby.r -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To

[ADMIN] Reg:import issue in PostgresSQL server

2011-05-21 Thread Vipul Kumar Singh02
Hi A Data dump from a PostgresSQL server was created using Postgres Version (PostgreSQL 7.4.1 on i386-unknown-freebsd5.3, compiled by GCC gcc (GCC) 3.4.2 [FreeBSD] 20040728). Now i am trying to import into PostgreSQL Server 4.8(Operating System - Windows 7) with GUI, but gui is not able to

Re: [ADMIN] Unable To Establish Connections

2011-05-21 Thread Sam Stearns
Anyone have any ideas on this? We're an ISP. I was thinking of the possibility of a hack attempt. On Tue, May 17, 2011 at 6:52 PM, Sam Stearns samtstea...@gmail.com wrote: Howdy, Environment: Postgres 8.2.3 Solaris 10 We were unable to make a remote postgres connection for ~2 hours this

Re: [ADMIN] pg_archivecleanup with multiple slaves

2011-05-21 Thread Tim Lewis
I don't actually use streaming replication, but what exactly is the problem with the hard link for each slave solution, and the slaves handling there own pg_archivecleanup? On Fri, May 20, 2011 at 11:30 AM, Fujii Masao masao.fu...@gmail.com wrote: On Fri, May 20, 2011 at 7:59 PM, Ben Lancaster

Re: [ADMIN] Reg:import issue in PostgresSQL server

2011-05-21 Thread Guillaume Lelarge
Le 05/19/2011 02:27 PM, Vipul Kumar Singh02 a écrit : [...] A Data dump from a PostgresSQL server was created using Postgres Version (PostgreSQL 7.4.1 on i386-unknown-freebsd5.3, compiled by GCC gcc (GCC) 3.4.2 [FreeBSD] 20040728). Now i am trying to import into PostgreSQL Server

Re: [ADMIN] Who is causing all this i/o?

2011-05-21 Thread Craig James
On 5/21/11 8:11 AM, Tom Lane wrote: Craig Jamescraig_ja...@emolecules.com writes: On 5/20/11 4:25 PM, Scott Marlowe wrote: On Fri, May 20, 2011 at 3:14 PM, Craig Jamescraig_ja...@emolecules.com wrote: Our development server (PG 8.4.4 on Ubuntu server) is constantly doing something, and I