Re: [ADMIN] Help: System requirements for postgresql 7.4.1

gres bin and lib in /usr/local/pgsql than in /usr/bin and /usr/lib. Thierry Missimilly Juan Carlos Diez wrote: > Hello, I'm evaluating that version and I can't find system requirements for it. > Could anybody please help me with these questions? > > 1.1. Hardware: >

Re: [ADMIN] Are there programs to graph database schema?

Hi, For a small schema, i've used PGACESS. There is a graphical editor which help you to draw boxes with the foreign keys. Thierry Juan Miguel wrote: > Hi, I use MS Visio Professional, and it works (not very good), but it works. > I ever wondered if there is a opensource tool,

Re: [ADMIN] find table name

ables pg_class and pg_index do not give the symbolic name with the "numbers". Thierry Missimilly. [EMAIL PROTECTED] wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > > > In postgresql all databases are stored in /data/base directory in > > numbers fo

Re: [ADMIN] Postgres client/server connection

You should try to launch postmaster -i or set tcpip_socket to true in postgresql.conf Regards Thierry Missimilly Akhona Damane wrote: > Hi > > I have been trying to connect to the DB from a client maching using > PgAdmin III but with error stating "server is not running&quo

Re: [ADMIN] how to recognise databses

One good and very usefull script for that is oid2name . You can find it in contrib/oid2name Thierry Missimilly   Ashok Chauhan wrote: we have made 4 databases in postgresql, now we want to know how can be recognize these database files in /var/lib/pgsql/data/base. ---(end

Re: [ADMIN] postgresql headers

By default they should be in /usr/local/pgsql/include [EMAIL PROTECTED] wrote: > Does anyone know where i can get the postgresql headers from or where > they might be located on my redhat machine. begin:vcard n:Missimilly;Thierry tel;fax:+33 (0)4 76 29 78 78 tel;work:+33 (0)4 76 29 7

Re: [ADMIN] postgresql and replication

synchronized the Master DB and the Slave DB, work only on the default port 5432. I'm waiting for an other machine to create the Slave DB on a different machine. Thierry Missimilly Chris Miles wrote: > Hi, we really want to get a reliable PostgreSQL replication > setup going, with a M

[ADMIN] How to get Postgres in ODBC

error message through the ODBC API. Thierry begin:vcard n:Missimilly;Thierry tel;fax:+33 (0)4 76 29 78 78 tel;work:+33 (0)4 76 29 74 54 x-mozilla-html:FALSE url:http:\\www.bull.com org:BIS/R&D adr:;;Bull SA, 1, rue de provence - BP 208;ECHIROLLES;;38432;FRANCE version:2.1 email;internet:[EMAIL

Re: [ADMIN] Backing up postgresql databases

password on the commande line. Thierry ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [ADMIN] Unable to get psql compiled

On Fri, 23 Jun 2000, Guoben Li wrote: > tab-complete.o(.text+0x74): undefined reference to > `rl_completion_append_character' > >Any hint/help is appreciated. > install 'GNU readline' library. -- Thierry Boudet -=- GNU/Linux operator -=- http://ww

Re: [ADMIN] postgres ate my server

named pg_sorttemp* in the db directory. and if you gote a partition full, postgres seems able to corrupt database. "Need allocate a new page, can't have, die, trash & burn." Just my 2 millieuros. -- Thierry Boudet is the GNU/Linux operator of http

Re: [ADMIN] High load postgres-driven Web sites

t; * experience ? > more ram. more ram. more ram. and carefully think about secondary indexes... -- Thierry Boudet is the GNU/Linux operator of http://www.123immo.com/ [EMAIL PROTECTED] Cuq-Toulza