[ADMIN] Are there programs to graph database schema?

I know that there are standard ways to graph relational databases. It occured to me that perhaps programs existed which simply parsed the table definitions and plotted the graphs for you. Anyone know of such a thing? Thanks. -Tony ---(end of broadcast)--

[ADMIN] Do Petabyte storage solutions exist?

I have a database that will hold massive amounts of scientific data. Potentially, some estimates are that we could get into needing Petabytes (1,000 Terabytes) of storage. 1. Do off-the-shelf servers exist that will do Petabyte storage? 2. Is it possible for PostgreSQL to segment a database betwe

Re: [ADMIN] Do Petabyte storage solutions exist?

[EMAIL PROTECTED] ("scott.marlowe") wrote in message news:<[EMAIL PROTECTED]>... > For quite some time. I believe the max table size of 32 TB was in effect > as far back as 6.5 or so. It's not some new thing. Now, the 8k row > barrier was broken with 7.1. I personally found the 8k row size ba

[ADMIN] Database storage bloat

I'm developing a database for scientific recordings. These recordings are traditionally saved as binary flat files for simplicity and compact storage. Although I think ultimately having a database is better than 1,000s of flat files in terms of data access, I've found that the database (or at least

Re: [ADMIN] Database storage bloat -- FOLLOWUP

I thought I'd make a followup to the question of storage bloat. I tried approaching the problem by living a little loosely with database normalization and use arrays instead of flattening everything out in the tables. So my original table, CREATE TABLE original ( dbIndex integer, index1 smallint,

Re: [ADMIN] Postgresql ssl mode

> Hi, > > the certificate was create in the directori of data, an the permision its > to user postgres. > > but the database not start > Print the postmaster log file (I think it's $PGDATA/serverlog). It should tell you specifically why the SSL mode can't start (permissions/existence/etc). -To

[ADMIN] Password with libpq

I'm setting my PostgreSQL server to demand md5 encrypted passwords from users. In my C programs (using libpq as the interface), it's no big deal to pass the password through PQconnectdb. However, what about in the general case where my client program doesn't know if a password is required or not.

Re: [ADMIN] Selecting HW RAID controller

[EMAIL PROTECTED] (pginfo) wrote in message news:<[EMAIL PROTECTED]>... > Hi all, > I am searching for good working HW RAID controller. > I will use linux as OS. > Also I will use SCSI. > I readet the docs about adaptec AHA2120S, but do not find any comments > about the driver supprt and how stabl

[ADMIN] Determining which users are logged onto the db

I have a few shell scripts that run when I log into the Postgres administrator account on my db (i.e. user = 'postgres'). I'd like to find a simple way to also list from the shell script which users are currently querying the db. I know I can see the db backends by using: database > ps ax | gre

[ADMIN] Re: Finding number of current connections

[EMAIL PROTECTED] ("Tauren Mills") wrote in message news:<[EMAIL PROTECTED]>... > I need to find a way to determine how many concurrent connections are being > made to the database server at any given time. You may find what you are looking for with Bruce Momjian's pgmonitor tool. http://grea

Re: [ADMIN] pg_dump & windows (what a mess...!)

[EMAIL PROTECTED] wrote in message > connectDB() -- connect() failed: No such file or directory > Is the postmaster running at 'localhost' and accepting connections on Unix > socket '5432'? > > I figured that, although through Windows clients everything works fine, > maybe from the command line

[ADMIN] psql option for writing schema

I seem to remember a psql option that dumped out the table schema. I can't seem to find it in the man for psql. Could someone point out the option to me? Thanks. -Tony ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.

Re: [ADMIN] psql option for writing schema

[EMAIL PROTECTED] (Lee Harr) wrote in message news:<9ubpl9$196u$[EMAIL PROTECTED]>... > On 30 Nov 2001 10:52:26 -0800, Tony Reina <[EMAIL PROTECTED]> wrote: > > I seem to remember a psql option that dumped out the table schema. I > > can't seem to find it in the m

Re: [ADMIN] Primary Key Problems

[EMAIL PROTECTED] (Phill Kenoyer) wrote in message news:<[EMAIL PROTECTED]>... > Here is a good one. I have three fields set for my primary key. Now I > thought that a primary key was unique, and dups can not be inserted. > I don't think primary keys per se are unique, but rather can be made

Re: [ADMIN] Allowing TCP/IP connections

Marc <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > In the postgres configuration file, which options do I have to enable to > allow TCP/IP connections: > > # > # Connection Parameters > # > #tcpip_socket = false > #ssl = false > > #max_connections = 32 # 1-1024 > > #

[ADMIN] Inherited tables vs non-inherited tables

I've been trying an inherited-table schema for my database and seem to be getting a performance hit. The old table looked like this: CREATE TABLE center_out ( subject text, arm char, target int4, rep

[ADMIN] Is this list working?

I'm reading the list through Google groups, but I haven't seen much activity on admin, hackers, sql, etc. over the last few weeks. Are there just not any posts or is something screwy with Google groups newsserver? I was hoping to see the status of 7.2. -Tony [EMAIL PROTECTED] -

Re: [ADMIN] performance problem with version 7.0.3

[EMAIL PROTECTED] wrote in message news:<[EMAIL PROTECTED]>... > Hello there > > > Please help me in analyzing this output. After vacuum/analyze, the > performance is ok for another month. > Are you regularily doing a "vacuum analyze"? This is a critical step to maintaining the database as Pos

[ADMIN] Alias for field name

I know this is probably a no-no, but I was just curious. I have two databases that are almost identical. Some of the minor differences include different field names. For instance, in one db a field called 'cell_name' is the same (more or less) as a field called 'file_name' in another db (actuall

[ADMIN] New vacuum for 7.2

I'm a little confused about the new vacuum for 7.2. The documentation says that the new vacuum doesn't lock the tables, but the old version of vacuum can be invoked by using the 'full' option. When would I need to use the old version of vacuum? It says that the old version shrinks the on disk siz

[ADMIN] Tape/DVD Backup Suggestions?

I'm looking into new ways of backing up the data in our lab, including the PostgreSQL database. Currently, we have a single DDS-2 tape drive capable of holding 8Gig compressed. However, it is slow (i.e. takes a day to backup about 40 Gig of information), spans multiple tapes, and makes it hard to

Re: [ADMIN] Tape/DVD Backup Suggestions?

Yes, I'm a little wary of hard disk based systems as my sole backup. I prefer something that allows me to have at least 2-3 different media backups (e.g. one this week, one last week, and one the week before last). Also, I like to be able to take a copy of the media home just because I'm paran

Re: [ADMIN] Tape/DVD Backup Suggestions?

Thanks everyone. I think I'll go with one of the tape solutions (DLT, Exabyte VXA-2, or AIT) after all. If I can get the 80G native/160 Gig compressed, then I can probably get buy with one or two tapes. That should make my single-file restores a little less onerous. -Tony [EMAIL PROTECTED] (K