Re: [ADMIN] tcp port

2004-03-13 Thread Michiel Lange
It is possible that due some weird stuff the port is not made free... check with $ netstat --all --numeric-ports -p | grep 5432 this -for example- is my output: tcp0 0 0.0.0.0:54320.0.0.0:* LISTEN 12775/postmaster unix 2 [ ACC ] STREAM L

[ADMIN] pgadmin3 software dependencies?

2004-03-13 Thread Vickriz Buenaventuura
good day to tthe guru.. i already download the wxWindow and pgadmin3 package. but when im innstalling them. its giving me an error of software library dependencies ssush as libc.so.5, libm.so.1, etc.. i did look my directory /usr/lib/ i just got libc.so and other aare missing. am i really misssi

[ADMIN] POrtability of ODBC and DBArtisan connection information

2004-03-13 Thread Byrocat
Here's the situation: We're doing user administration on a pile (250+) DB2 databases, and are using ODBC to provde the connection to these database (plus a whole pile of ones from other database providers). The desktop is Windows 2000 and we're running the client ODBC software for DB/2. Right now

[ADMIN] using disable-triggers in pg_dump

2004-03-13 Thread Nick Fankhauser - Doxpop
Hi- One of our processes requires merging data from a staging database into a production database. I'd like to do this without taking the production database off-line, but I'm running into a problem with triggers. One of the tables is populated and maintained solely by triggers set up on three ot

Re: [ADMIN] using disable-triggers in pg_dump

2004-03-13 Thread Bruce Momjian
Nick Fankhauser - Doxpop wrote: > Hi- > > One of our processes requires merging data from a staging database into a > production database. I'd like to do this without taking the production > database off-line, but I'm running into a problem with triggers. > > One of the tables is populated and ma

Re: [PERFORM] [ADMIN] syslog slowing the database?

2004-03-13 Thread Christopher Kings-Lynne
You could also consider not using syslog at all: let the postmaster output to its stderr, and pipe that into a log-rotation program. I believe some people use Apache's log rotator for this with good results. Not an option I'm afraid. PostgreSQL just jams and stops logging after the first rotation

Re: [PERFORM] [ADMIN] syslog slowing the database?

2004-03-13 Thread Joshua D. Drake
Not an option I'm afraid. PostgreSQL just jams and stops logging after the first rotation... Are you using a copy truncate method to rotate the logs? In RedHat add the keyword COPYTRUCATE to your /etc/logrotate.d/syslog file. Sincerely, Joshua D. Drake I know some people use this in produc

Re: [ADMIN] [PERFORM] started Data Warehousing

2004-03-13 Thread Joshua D. Drake
Pablo Marrero wrote: Hello people! I have a question, I am going to begin a project for the University in the area of Data Warehousing and I want to use postgres. Do you have some recommendation to me? Regarding what? Do you have an specific questions? Sincerely, Joshua D. Drake Thanks!!

Re: [ADMIN] [PERFORM] started Data Warehousing

2004-03-13 Thread brew
Pablo. > I have a question, I am going to begin a project for the University in > the area of Data Warehousing and I want to use postgres. Do you have > some recommendation to me? Yes. Set up a linux machine if you don't have access to one so you can load postgresql and start learning how p

Re: [PERFORM] [ADMIN] syslog slowing the database?

2004-03-13 Thread Chris Smith
It might depend on how you're rotating it. Try the copy/truncate method instead of moving the log file. If you move the log file to another filename you usually have to restart the app doing the logging before it starts logging again. Chris. -Original Message- From: [EMAIL PROTECTED] [ma