Re: [ADMIN] Out of buffer error

I am running 7.3.2. I will update to 7.3.4 as soon as possible. If the problem is still there after the update, I will post once more the issue. Thank you for your help Best Regards Christian Brosig Gaetano Mendola [EMAIL PROTECTED] writes: Tom Lane wrote: Christian Brosig [EMAIL PROTECTED]

Re: [ADMIN] performance problem - 10.000 databases

On Thu, 6 Nov 2003, William Yu wrote: scott.marlowe wrote: Note that if you're on an IDE drive and you haven't disabled the write cache, you may as well turn off fsync as well, as it's just getting in the way and doing nothing, i.e. the IDE drives are already lying about fsync so why

Re: [ADMIN] small table occupies many relpages

, 07.11.2003, 21:45, Markus Bertheau : , 07.11.2003, 16:45, Tom Lane : Markus Bertheau [EMAIL PROTECTED] writes: It has a unique index on virtual_domain. Every day we do 1 queries of the form insert into virtual_domains values (default, 'www.something.de') So you're

[ADMIN] CREATE DATABASE

Hi, PostgreSQL is not consistent in the way it uses upper/lower case to create databases and access it. Why psql -c 'CREATE DATABASE name_db' uses lower(name_db) an less the name is enclosed by but psql name_db ? Take a look psql template1 -c create database MYDB psql MYDB psql: FATAL

Re: [ADMIN] revoke create table from a user

no, not on the database. I specified NOCREATEDATABASE and NOCREATEUSER when creating the user. and...the user does not belong to any groups. the user in question is bolded. usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig

Re: [ADMIN] CREATE DATABASE

jose [EMAIL PROTECTED] writes: PostgreSQL is not consistent in the way it uses upper/lower case to create databases and access it. Folding case in unquoted names in SQL commands is required by the spec. On the other hand, we decided some time ago that names appearing in command-line arguments

[ADMIN] Vacuum verbose and entry timestamp

pgSql 7.4.rc1 Hi, Is there a way to force VACUUME VERBOSE to show timestamp for each entry it writes ? Thanks __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree ---(end of

Re: [ADMIN] CREATE DATABASE

jose writes: PostgreSQL is not consistent in the way it uses upper/lower case to create databases and access it. Why psql -c 'CREATE DATABASE name_db' uses lower(name_db) an less the name is enclosed by but psql name_db ? These are two different language bindings for the same

[ADMIN] Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling at 100% CPU w/ no disk access

Hi, I'm trying to upgrade our 25Gb database from 7.1.3 to 7.3.4 - pg_dump worked fine, although piping through split to get a set of 1Gb files. But, after a few attempts on using pg_restore to get the data into the new installation I'm having a few problems; basically it restores the first few

Re: [ADMIN] pg_shadow dump annoying problem

Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: [ pg_dumpall emits this: ] DELETE FROM pg_shadow WHERE usesysid (SELECT datdba FROM pg_database WHERE datname = 'template0'); Now if the file pg_user.sql is used accidentally by a user that is not postgres the result is that all users

Re: [ADMIN] Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling at 100%

Shane Wright wrote: Hi, I'm trying to upgrade our 25Gb database from 7.1.3 to 7.3.4 - pg_dump worked fine, although piping through split to get a set of 1Gb files. But, after a few attempts on using pg_restore to get the data into the new installation I'm having a few problems; basically it

Re: [ADMIN] Problems Compiling eRserver

On Fri, Nov 07, 2003 at 02:44:54PM -0600, Matthew Montgomery wrote: My configure line is: ./configure --with-pgincludes=/usr/include/pgsql/ # (this location is provided by the postgresql-devel RPM) Are you sure that's the right one? You actually need to be pointing to spi.h, IIRC. But

Re: [ADMIN] Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling at 100%

Gaetano, er, shedloads of this read(0, , 4096) = 0 read(0, , 4096) = 0 read(0, , 4096) = 0 read(0, , 4096) = 0 read(0, , 4096) = 0 read(0, , 4096) = 0 read(0, ,

[ADMIN] ER diagram tool for PostgresSQL7.3

Hi: Is there a ER diagram tool someone can recommend for PostgreSQL? I should be able to create ER diagram from existing database also (reverse engineering). Any open source product would be ideal. Thanks, Gautam ---(end of broadcast)--- TIP

Re: [ADMIN] ER diagram tool for PostgresSQL7.3

Gautam, This is not specifically for diagramming ERD's but I have used OpenOffice Draw for entity relationship diagrams. You can't generate SQL from it but it works great for all my diagramming needs. OO is open source also. In the past I used M$ Visio but I'll pass on that for philosophical

Re: [ADMIN] ER diagram tool for PostgresSQL7.3

On Mon, 2003-11-10 at 13:58, Gautam Saha wrote: Is there a ER diagram tool someone can recommend for PostgreSQL? I should be able to create ER diagram from existing database also (reverse engineering). Any open source product would be ideal. I'd like an open source product too, but

Re: [ADMIN] ER diagram tool for PostgresSQL7.3

On Mon, 2003-11-10 at 16:58, Gautam Saha wrote: Hi: Is there a ER diagram tool someone can recommend for PostgreSQL? DIA isn't too bad: http://www.lysator.liu.se/~alla/dia/ This goes from DIA to PostgreSQL: http://freshmeat.net/projects/dia2postgres/?topic_id=66%2C259%2C916 And this goes