[ADMIN] problem backup

2003-12-05 Thread Ramesh PAtel
Hi ALL i have problem after backup i have three database on one server. when i backup is done complete. but after backup my pc's speed is very slow. it is requery to restart PC. please give some ans. Ramesh Patel ---(end of broadcast)--- TIP 6: H

[ADMIN] Admin Position in Las Vegas

2003-12-05 Thread postgres timeless
Are you a good Unix/PostgreSQL admin with some MySQL experience? Do you want to help a company migrate off of MS SQL Server? Do you want to live and work in Las Vegas for a fun company of good computer techs? We need you. Contact me. -- Tim Ellis Senior Database Architect and author, tedia2sql (

[ADMIN] PostgreSQL Contractor Help

2003-12-05 Thread John Gibson
Hi, all. We have a web application which has apache-enhydra(java app server)-postgresql architecture. We need some immediate contractor help to identify the causes of some serious performance problems. We suspect that some changes in the way we are requesting data from the database might rea

Re: [ADMIN] row sorting in pgadmin3?

2003-12-05 Thread Godshall Michael
Title: RE: [ADMIN] row sorting in pgadmin3? Hi, I don't believe this an option in pgadmin3 at the moment.  You will have to add an "order by" to your sql statement. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Info Desk Sent: Thursday, De

Re: [ADMIN] Trigger to call an external program

2003-12-05 Thread Peter Eisentraut
On Thursday 04 December 2003 16:36, Stephan Szabo wrote: > > I thought I was onto a winner with pgplsh, but I can't get it to > > compile with 7.3.4, although it compiled beautifully with 7.2.1. > > It takes a little bit of work to get pgplsh to compile for my devel > system (notably that I needed

[ADMIN] row sorting in pgadmin3?

2003-12-05 Thread Info Desk
Hi all- In PgAdmin II it was (is) possible to sort the rows based on data in a column (just by clicking on the column header). I can't seem to figure out how to do that in PgAdmin III. Any help will be greatly appreciated. -Laurent ---(end of broadcast)--

[ADMIN] Mammoth PostgreSQL Replicator

2003-12-05 Thread Kris Kiger
I saw that Mammoth PostgreSQL Replicator was announced on Postgresql.org. Just wondering if anyone has had any experience with it. Kris ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregis

Re: [ADMIN] Postrgres data restoration problem

2003-12-05 Thread Tom Lane
Jim Cochrane <[EMAIL PROTECTED]> writes: > I'm looking for help restoring old postgres databases on a linux system > after a reinstall of Redhat (including posgresql). How old? We need to know the exact PG version number. > I was able to connect to an old database (e.g., with psql dbname), but >

Re: [ADMIN] TCP/IP connection

2003-12-05 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On 5 Dec 2003, Ashok Chauhan wrote: > i want to accsess my postgresql data base from network it is only > possible when i start postgresql by following command:- > postmaster -i -D /var/lib/pgsql/data > after rebooting the system it does not lis

Re: [ADMIN] TCP/IP connection

2003-12-05 Thread Frank Finner
On Fri, 5 Dec 2003 17:22:55 +0530 [EMAIL PROTECTED] wrote: > hi > > i want to accsess my postgresql data base from network it is only > possible when i start postgresql by following command:- > postmaster -i -D /var/lib/pgsql/data > after rebooting the system it does not listen for TCP/IP connect

[ADMIN] TCP/IP connection

2003-12-05 Thread Ashok Chauhan
hi i want to accsess my postgresql data base from network it is only possible when i start postgresql by following command:- postmaster -i -D /var/lib/pgsql/data after rebooting the system it does not listen for TCP/IP connection. how can i configure it for listening TCP/IP connection after reboot

Re: [ADMIN] Postrgres data restoration problem

2003-12-05 Thread Sai Hertz And Control Systems
Dear Jim Cochrane, I'm looking for help restoring old postgres databases on a linux system after a reinstall of Redhat (including posgresql). It's the same version of redhat and of postgres I was using before the resinstall, but I've not been able to get the database server to see the old databas

Re: [ADMIN] Trigger to call an external program

2003-12-05 Thread Alan Graham
I'll try the fix and compile of pgplsh, as suggested by Stephan. (thanks :-) I'd assumed that the errors I was seeing were indicative of much larger compatibility problems. Just shows what "Assume" does :-) As you say, using trigger worries me, because of rollbacks. I'd thought of using NOTIFY,

[ADMIN] Postrgres data restoration problem

2003-12-05 Thread Jim Cochrane
I'm looking for help restoring old postgres databases on a linux system after a reinstall of Redhat (including posgresql). It's the same version of redhat and of postgres I was using before the resinstall, but I've not been able to get the database server to see the old databases. The old data is