Re: [ADMIN] PostgreSQL as a DDBMS

2004-08-20 Thread Gaetano Mendola
Rodrigo Bonfa wrote: Friends, I would like to know if PostgreSQL can run as a Distributed Data Base Management System. Is possible, throught PostgreSQL, to implement horizontal partition, this is, to fragment tables horizontally? For example, can I have a Data Base with 1 table, where it is hori

[ADMIN] How to disconnect client from Server forcefully

2004-08-20 Thread bala srini
Hi  I want to disconnect all already established REMOTE DB connections from the server without restarting the Postmaster daemon. Requirement is that diconnect should be done from the server side. Actually I tried to kill the corresponding process(Remote Db connection) in the server. But server

Re: [ADMIN] How to disconnect client from Server forcefully

2004-08-20 Thread Olivier Hubaut
On 20 Aug 2004 12:05:47 -, bala srini <[EMAIL PROTECTED]> wrote: Hi  I want to disconnect all already established REMOTE DB connections from the server without restarting the Postmaster daemon. Requirement is that diconnect should be done from the server side. Actually I tried to kill

Re: [ADMIN] How to disconnect client from Server forcefully

2004-08-20 Thread bala srini
Thanks for ur reply... Actually I can set the tcpipsocket option in postgresql.conf file to false. This will block all further remote connection to my server. But what will happen to already existing remote connection? I want to disconnect this also ..   Sorry I can't change the firewall setting

Re: [ADMIN] How to disconnect client from Server forcefully

2004-08-20 Thread G u i d o B a r o s i o
how do you kill the process? Regards, Guido > > Thanks for ur reply... > Actually I can set the tcpipsocket option in postgresql.conf file to false. This > will block all further remote connection to my server. But what will happen to > already existing remote connection? I want to disconnect t

Re: [ADMIN] How to disconnect client from Server forcefully

2004-08-20 Thread G u i d o B a r o s i o
Also,... how does the aplication performs the connection? Describe the enviroment please. (web, perl (Pg) -> db ie) guido > > Thanks for ur reply... > Actually I can set the tcpipsocket option in postgresql.conf file to false. This > will block all further remote connection to my serv

Re: [ADMIN] How to disconnect client from Server forcefully

2004-08-20 Thread bala srini
Assuming that the enviroment of establishing the connection in client may be anything.  I want to terminate these remote connections from server side. I referred killing the process in server side. this porcess is corresponding to the client connsction. After killing also, Client will respawn th

Re: [ADMIN] problem with setting PATH variable

2004-08-20 Thread Bruno Wolff III
On Thu, Aug 19, 2004 at 21:41:17 -0700, "Pradeepkumar, Pyatalo (IE10)" <[EMAIL PROTECTED]> wrote: > > Hi all, > > I have installed PostgreSQL 7.4.3 on LINUX 7.2 and some other machines have > LINUX 8.0. You specify a distribution name, as there isn't a Linux 7.2 or 8.0, but I believe there may

Re: [ADMIN] problem with setting PATH variable

2004-08-20 Thread Pradeepkumar, Pyatalo (IE10)
I am sorry for the confusion. One machine, I am running Red Hat Linux - 8.0 with kernel version 2.4.18. Other machines have Red Hat Linux - 7.2 with kernel version 2.4.7 Hope this is what you are expecting. I am a newbie to postgresql and Linux, i have no idea about .bashrc,.cshrc,.profile. I do

Re: [ADMIN] problem with setting PATH variable

2004-08-20 Thread Bruno Wolff III
On Fri, Aug 20, 2004 at 06:44:27 -0700, "Pradeepkumar, Pyatalo (IE10)" <[EMAIL PROTECTED]> wrote: > > > I am sorry for the confusion. One machine, I am running Red Hat Linux - 8.0 > with kernel version 2.4.18. > Other machines have Red Hat Linux - 7.2 with kernel version 2.4.7 > Hope this is wh

Re: [ADMIN] PostgreSQL as a DDBMS

2004-08-20 Thread Goulet, Dick
If your looking to have users connect to one database & see the entire enterprise worth of databases then Postgres is not what you want. Have damanagement get out their wallet & buy Oracle instead. It's made to purpose. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Messa

Re: [ADMIN] problem with setting PATH variable

2004-08-20 Thread Pradeepkumar, Pyatalo (IE10)
I have installed postgresql by building from a source tar ball. so every time i log in to the postgres session i have to set the PATH variable to /usr/local/bin, is there way so that i dont have to set the PATH variable every time i log into the postgres session. -Original Message- From:

Re: [ADMIN] problem with setting PATH variable

2004-08-20 Thread Bruno Wolff III
On Fri, Aug 20, 2004 at 07:25:22 -0700, "Pradeepkumar, Pyatalo (IE10)" <[EMAIL PROTECTED]> wrote: > > I have installed postgresql by building from a source tar ball. > so every time i log in to the postgres session i have to set the PATH > variable to /usr/local/bin, is there way so that i dont

[ADMIN] question

2004-08-20 Thread Dariusz Sobierajewicz
Hi, I have following problem. I have postgresql dump database. I don't have posgresql server intalled. Is there a way to restore that data?   thanks. Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now.

Re: [ADMIN] question

2004-08-20 Thread Bruno Wolff III
On Fri, Aug 20, 2004 at 10:25:06 -0700, Dariusz Sobierajewicz <[EMAIL PROTECTED]> wrote: > Hi, > I have following problem. I have postgresql dump database. I don't have posgresql > server intalled. Is there a way to restore that data? Install a postgres server and then use pg_restore or psql to