Re: [ADMIN] Running Postgres Daemons with same data files

2003-12-10 Thread Bhartendu Maheshwari
Dear UC, You are right for the HA solution but at the same time we are also implementing the load balancing solution so we can't have for one Node 2 different processing entity and database as well. We try to provide solution for HA, load balancing both and in that there are 2 different processing

[ADMIN] How can i know the users that are loged in

2003-12-10 Thread Vasilis Ventirozos
Hi all i want to ask something about user managment , How can i know the users that are loged thru an SQL command or how can i know who i am (my username) thru SQL again i can see that the users are loging so when i connect to a database a triger (maybe) raises an notise that user vasilis is loge

Re: [ADMIN] pg 7.4 on debian

2003-12-10 Thread Oliver Elphick
On Sat, 2003-12-06 at 08:04, Erwin Brandstetter wrote: > "Miquel van Smoorenburg" wrote: > > > It sure is. > > www.mail-archive.com/[EMAIL PROTECTED]/msg71008.html > > > Thnax for the hint - but it sure ain't. > people.debian.org has been down since the debian hack. > I am also desperately looki

Re: [ADMIN] How can i know the users that are loged in

2003-12-10 Thread Antonis Antoniou
Vasilis Ventirozos wrote: Hi all i want to ask something about user managment , How can i know the users that are loged thru an SQL command or how can i know who i am (my username) thru SQL again i can see that the users are loging so when i connect to a database a triger (maybe) raises an noti

Re: [ADMIN] Running Postgres Daemons with same data files

2003-12-10 Thread William Yu
Bhartendu Maheshwari wrote: Dear Hal, Frank, Oli and all, I understand what you all trying to say, I know this is not good way of designing, but we are planning for using the database for the keeping mobile transactions and at the same time we need to provided the HA solutions. The one solution i

Re: [ADMIN] Running Postgres Daemons with same data files

2003-12-10 Thread Andrew Rawnsley
On Dec 10, 2003, at 12:25 PM, William Yu wrote: Bhartendu Maheshwari wrote: Dear Hal, Frank, Oli and all, I understand what you all trying to say, I know this is not good way of designing, but we are planning for using the database for the keeping mobile transactions and at the same time we need

Re: [ADMIN] Running Postgres Daemons with same data files

2003-12-10 Thread John Gibson
Bhartendu, In my humble opinion, you would be well served if you listened to all the nice people on this list. Use a local disk subsystems with RAID-type storage, use replication to have a second "standby" system available if the first one fails. The path you seem anxious to trod will get ver

Re: [ADMIN] Running Postgres Daemons with same data files

2003-12-10 Thread Bhartendu Maheshwari
Dear All, I got all your points, thanks for such a great discussion, Now the last thing I want is how can I close the data files and flush the cache into the data files. How can I do this in postgresql I will also try with RAID and other suggested way you all suggested. regards bhartendu O

Re: [ADMIN] Postrgres data restoration problem

2003-12-10 Thread Jim Cochrane
> Jim Cochrane <[EMAIL PROTECTED]> writes: > >> How old? We need to know the exact PG version number. > > > cat PG_VERSION > > 7.2 > > That's not exact, it only tells the major release number. > "postmaster --version" was what I was looking for. It outputs: postmaster (PostgreSQL) 7.2.1 > >