[ADMIN] E-R Tool

Can someone suggest an E-R tool that will read a _PG_ database and create an E-R diagram - crows feet and all? Are there any that are available for free? Thanks ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister c

[ADMIN] Howto/wherefrom win98 install [ref:ppg]

Hi,   I searched the postgresql.org site but I don't understand how to get a postmaster running on windows 98/2000.   Can someone please give some pointers here.   Is there a package tarball  file with binaries and if needed cygwin?   Thanks   paul  

Re: [ADMIN] Replication/Mirror Help

In the last exciting episode, [EMAIL PROTECTED] ("Mr. Darshan Patel") wrote: > I had install postgresql server on two different port : default(5432) and > other(5545), now I have to setup replication/mirror between them So what are > the steps/setup procedure. That presumably depends on which r

Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannotassign

Siddharth Rath (sirath) wrote: Hi Rob, Please find the output of "strace -f /apps/systran/postgresql/bin/pg_ctl start -D /apps/systran/postgresql/data-linux > s.out 2> s.err" in the below provided URLs: http://us.f2.yahoofs.com/bc/40c0ea30_116c8/bc/My+Documents/s.err.err?bfd6OwABBgQwEsbt http://u

Re: [ADMIN] determining when a database was created

Somasekhar Bangalore wrote: Hi All, Is there a tool , where in i can convert data from postgres 7.3.2 to oracle 9i. http://www.oracle.com/support/index.html?contact.html thanks in advance som U'r welcome. Regards Gaeatano Mendola ---(end of broadcast)-

Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannotassign

Hi Rob, Please find the output of "strace -f /apps/systran/postgresql/bin/pg_ctl start -D /apps/systran/postgresql/data-linux > s.out 2> s.err" in the below provided URLs: http://us.f2.yahoofs.com/bc/40c0ea30_116c8/bc/My+Documents/s.err.err?bfd6OwABBgQwEsbt http://us.f2.yahoofs.com/bc/40c0ea30_

[ADMIN] win32/w98 'How much/minimum disk space req'd for postgresql?' [ref:ppg.%001%^]

Hi,   Can anyone tell me huch much/ or how minimum disk space is needed for the win32 version of postgresql to run on win98x   thanks,   paul.  

Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannotassign

Siddharth Rath (sirath) wrote: Hi Rob, I did run the script from http://myclass.missouri.edu/~atb6x2/NETSERV/NS_serverpl.html and it didn't give any error and the O/P of netstat -plunta | grep 5432 (Not all processes could be identified, non-owned process info will not be shown, you would have to

Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannotassign

Hi Rob, I did run the script from http://myclass.missouri.edu/~atb6x2/NETSERV/NS_serverpl.html and it didn't give any error and the O/P of netstat -plunta | grep 5432 (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) tcp

Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannotassign

Tom Lane wrote: "Siddharth Rath (sirath)" <[EMAIL PROTECTED]> writes: Surprisingly .s.PGSQL.5432 file is not getting created in /tmp directory ( I believe this should be created). No, it shouldn't, because that is associated with the creation of the Unix socket file, which happens after creation o

Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannotassign

Hi Tom, I don't understand what you meant by "This is a kernel-level issue and you need to be inquiring ..." . If you please tell me what and how I should enquire and what may be the possible reason for this bind call failure then I can contact our Sysadmin to help me out. Thanx and regards Sidd

Re: [ADMIN] Setting vacuum_mem for vacuumdb utility

Bruce Momjian wrote: Jeff Boes wrote: I just discovered that the use of a much larger setting on vacuum_mem has a joyous effect on the throughput of VACUUM FULL for some of our tables. However, all of my maintenance scripts use "vacuumdb" (the command-line utility) instead of psql. How can I

Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannotassign

"Siddharth Rath (sirath)" <[EMAIL PROTECTED]> writes: > Surprisingly .s.PGSQL.5432 file is not getting created in /tmp directory ( I believe > this should be created). No, it shouldn't, because that is associated with the creation of the Unix socket file, which happens after creation of the TCP s

[ADMIN]

For tcl, I've run ./configure --enable-shared to have a tcl like a shared library and for tk, I've run ./configure --enable-shared --with-tcl to have a tk like a shared library. The installation of tcl and of tk work fine. For postgreSQL, I've run ./configure --with-tclconfig --with-tkconfig --with

Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannotassign

Hi Rob, Thanx for the response. The O/P of netstat -na | grep 5432 is : tcp0 0 0.0.0.0:54320 0.0.0.0:* LISTEN udp0 0 0.0.0.0:54321 0.0.0.0:* Surprisingly .s.PGSQL.5432 file is not getting created in /tmp directory ( I believ

Re: [ADMIN] Autovacuum option in init script

Attached is a script I created to run on Redhat. Someone might find it useful. It's not a big deal to make it run as the next script after postgresql.   Regards Donald Fraser   - Original Message - From: Roy Walker To: [EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 9:5

[ADMIN] Autovacuum option in init script

I am sure someone else has mentioned this, but adding an option in the init script for the next Postgres release to start pg_autovacuum with Postgres.   I understand some people (don’t know who, but I am sure they are out there) would rather use cron scripts, so making it an option that i

[ADMIN] Replication/Mirror Help

Hello, I had install postgresql server on two different port : default(5432) and other(5545), now I have to setup replication/mirror between them So what are the steps/setup procedure. thanks, Darshan Patel. ---(end of broadcast)--- TIP 6: Have

[ADMIN]

I've run the file init-base under the identity of  postgres and I've the following error messages : function soundex(text) does not exist HINT:   No function matches the given name and argument types. You may need to add explicit type casts ERROR:    insert ou update on table "membres" violates for

Re: [ADMIN] Knowing postgres processes..

Idle processes are not uncommon on a database. Basically their client applications that don't have anything for the database to do at the present time. Now if they persist for a long period of time without ever changing state to active, then something is probably wrong. Dick Goulet Senior Ora

Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannotassign

Siddharth Rath (sirath) wrote: The O/P of >netstat -plunt | grep 5432 what about just : netstat -na | grep 5432 to see if any 5432 stuff is hanging around and if so in what state... It may be that you are missing the evidence of the problem because you filtered -plut (process id, listening, udp, t

Re: [ADMIN] Knowing postgres processes..

JM <[EMAIL PROTECTED]> writes: > this are processes running on my box. is it normal to see > "idle" processes? That says you've got client processes holding open connections without doing anything. You probably want to look at your client-side logic. regards, tom l