Re: [ADMIN] Documenting a DB schema

On Dienstag, 4. März 2008 Shahaf Abileah wrote: > create table table_with_comments(a int comment 'this is > column a...'); > (see http://dev.mysql.com/doc/refman/5.0/en/create-table.html) > However, Postgres doesn't support the "comment" keyword.  Is there an > alternative? This sounds nice at fir

Re: [ADMIN] [GENERAL] Documenting a DB schema

Shahaf Abileah wrote: I’m looking for a systematic way to document the schema for the database behind our website (www.redfin.com ), so that the developers using this database have a better idea what all the tables and columns mean and what data to expect. Any recommen

[ADMIN] Documenting a DB schema

I'm looking for a systematic way to document the schema for the database behind our website (www.redfin.com ), so that the developers using this database have a better idea what all the tables and columns mean and what data to expect. Any recommendations? It would be g

Re: [ADMIN] [SQL] Documenting a DB schema

Shahaf Abileah wrote: I'm looking for a systematic way to document the schema for the database behind our website (www.redfin.com ), so that the developers using this database have a better idea what all the tables and columns mean and what data to expect. Any recomme

[ADMIN] Delete from base table and not partitions

Question: I have a base table with several temporal partitions like this: base_table partition_1 partition_2 There are check rules on partitions, and trigger rules on the base table to ensure data loaded into base_table goes to a correct partition. I added partition_3 and create

[ADMIN] Delete from base table and not partitions

Question: I have a base table with several temporal partitions like this: base_table partition_1 partition_2 There are check rules on partitions, and trigger rules on the base table to ensure data loaded into base_table goes to a correct partition. I added partition_3 and create

Re: [ADMIN] Documenting a DB schema

MicroOlap (or MicrOlap) does a nice job of creating schema diagrams for postgres. I have had a little trouble with re-engineering databases that have had a lot of alterations, however. But their tech support is reasonable. Mary Michael Monnerie wrote: On Dienstag, 4. März 2008 Shahaf Abi

[ADMIN] after initdb - Re: How to CREATEDB in commandline with no prompt for password

Rajiv Rajaian-2 wrote: > > [EMAIL PROTECTED] ~]# su postgres -c "createdb postgres" > could not change directory to "/root" > CREATE DATABASE > [EMAIL PROTECTED] ~]# echo "CREATE USER globus WITH PASSWORD 'globus' > CREATEDB;" > | > psql -U postgres -d postgres > psql: FATAL: Ident authentica

[ADMIN] after initdb - Re: How to CREATEDB in commandline with no prompt for password

Rajiv Rajaian-2 wrote: > > [EMAIL PROTECTED] ~]# su postgres -c "createdb postgres" > could not change directory to "/root" > CREATE DATABASE > [EMAIL PROTECTED] ~]# echo "CREATE USER globus WITH PASSWORD 'globus' > CREATEDB;" > | > psql -U postgres -d postgres > psql: FATAL: Ident authentica

[ADMIN] Replacing the corrupt "global" folder with older one

PostgreSQL version: 8.1.2 Operating system: Windows XP/2003 The PostgreSQL service is not starting anymore. When I manually start it, it said something like it started but ended immediately because it had no work to do. I encountered this error before but a simple re-installation fixed it. Thi

[ADMIN] GRANT ALL ON recursive for all tables in my scheme?

I recently searched for a way to grant permissions to a new created user for all tables in a scheme or database. I just found ways who uses psql and scripts. But I'm astonished that there is no way to do it with the "grant all on database [schema]..."-option. Actually i thought that a grant on a sc

[ADMIN] Postgres port bindings changed after box restart

Our redhat server was restarted and postgres is showing different databases on different ports? Could someone explain how this might happen and where this information comes from (what conf for port bindings) as is there a way of guarenteeing this will not happen on restarts. Cheers Dan

Re: [ADMIN] GRANT ALL ON recursive for all tables in my scheme?

"A Lau" <[EMAIL PROTECTED]> writes: > I recently searched for a way to grant permissions to a new created user for > all tables in a scheme or database. I just found ways who uses psql and > scripts. But I'm astonished that there is no way to do it with the "grant > all on database [schema]..."-opt

[ADMIN] using warm standby with drbd???

Hi All! I have configured the warm standby using WAL FILES and DRBD. The wal files are generated as server A. I am using DRBD to replicate these wal files between server A and server B. The DRBD service is running as Primary on Server A and secondary on Server B. The wal_files are written to the s

Re: [ADMIN] after initdb - Re: How to CREATEDB in commandline with no prompt for password

bwnabble wrote: Did you have your METHODs set to "trust" in your "pg_hba.conf" file (in the $PGDATA directory)? My question is, similar to yours, is there a way to: 1) run "initdb" as user "postgres" on an empty $PGDATA directory to start from scratch 2) change the METHODs in "$PGDATA/pg_hba.co

[ADMIN] ident authentication problem

Hello I am newbie to postgresql I have to make project using this . I am learning it but at every step i am getting error . now I am stuck with the error -bash-3.2$ psql -d xnat -f sql/xnat.sql -U xnat psql: FATAL: Ident authentication failed for user "xnat"

Re: [ADMIN] ident authentication problem

On Wed, 5 Mar 2008 10:01:46 +0530 <[EMAIL PROTECTED]> wrote: > > Hello > I am newbie to postgresql I have to make project using > this . I am learning it but at every step i am getting error . now I > am stuck with the error > >-bash-3.2$ psql -d xnat -f sql/xnat.sql -U xnat >

[ADMIN] unuscribe

-- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-admin