[ADMIN] pgcluster usage??

2005-04-20 Thread Askar Zaidi
Hello, Iam considering pgcluster for our data center. Is it a good solution keeping in mind High availability as the key issue?? thanks Askar Zaidi Central Computer Facility, National Physical Laboratory, New Delhi, India ---(end of broadcast)---

Re: [ADMIN] brute force attacking the password

2005-04-20 Thread Bruno Wolff III
On Tue, Apr 19, 2005 at 22:54:32 +0200, Wim Bertels <[EMAIL PROTECTED]> wrote: > > not an easy problem: it always seems to end up in DoS vs Brute Force Cracking. > So the only good and simple solution i can think of: use the best possible > password encrytion (or sufficient, a statistically ze

Re: [ADMIN] Troubleshooting Postgres7.4

2005-04-20 Thread Michael Fuhr
On Tue, Apr 19, 2005 at 02:11:47PM -0400, Bobb Shields wrote: > > I'm running 7.4, and I recently did a few upgrades, which seem to have > broken it. Could you expand on "seem to have broken it"? What are you doing and what unexpected behavior or error messages are you seeing? > I believe that

[ADMIN] Database syncronization

2005-04-20 Thread Shadow
Hy all ! Is there any tool, middelware, or feature to syncronize 2 databases (With the same schema, ofcourse) I have an application that runs from 2 points. One of this points has a master database and the other point neds to sync its data daily from the master. Any suggestion ? Thanks ! -

Re: [ADMIN] Database syncronization

2005-04-20 Thread Jim C. Nasby
http://www.google.com/search?q=postgresql+replication And http://gborg.postgresql.org/project/slony1/projdisplay.php, which is missing for some reason... On Wed, Apr 20, 2005 at 06:44:26PM +0200, Shadow wrote: > > Hy all ! > > Is there any tool, middelware, or feature to syncronize 2 databases

[ADMIN] help

2005-04-20 Thread sidhki adha
help, why my postgresql doesn,t run in port 5432 is my postmaster running in other port thank i am new using postgresql regard, sidhki -- ___ Check out the latest SMS services @ http://www.linuxmail.org This allows you to send and receive SMS through y

Re: [ADMIN] Database syncronization

2005-04-20 Thread John DeSoi
On Apr 20, 2005, at 12:44 PM, Shadow wrote: Is there any tool, middelware, or feature to syncronize 2 databases (With the same schema, ofcourse) I have an application that runs from 2 points. One of this points has a master database and the other point neds to sync its data daily from the maste

Re: [ADMIN] Database syncronization

2005-04-20 Thread Steve Crawford
On Wednesday 20 April 2005 9:44 am, Shadow wrote: > Hy all ! > > Is there any tool, middelware, or feature to syncronize 2 databases > (With the same schema, ofcourse) > > I have an application that runs from 2 points. One of this points > has a master database and the other point neds to sync its

Re: [ADMIN] help

2005-04-20 Thread Scott Marlowe
On Wed, 2005-04-20 at 13:44, sidhki adha wrote: > help, > why my postgresql doesn,t run in port 5432 is my postmaster running in other > port > thank i am new using postgresql Most likely you need to set tcpip_socket=true in your postgresql.conf file (or start the postmaster with a -i switch if y

[ADMIN] VACUUM with a small table too much delayed.

2005-04-20 Thread FBaron
Hi, I'm running a vaccum process to a table with 1427 records and three indexes with the same size. This process is running 6 hours ago and does not finish, I had to kill it. I did the same to a table with 300.000 records and two indexes . and it finished 20 minutes later. What can it be ha

Re: [ADMIN] VACUUM with a small table too much delayed.

2005-04-20 Thread Tom Lane
[EMAIL PROTECTED] writes: > Hi, I'm running a vaccum process to a table with 1427 records and three > indexes with the same size. This process is running 6 hours ago and does > not finish, I had to kill it. Was it actually *doing* anything, or just sitting? Perhaps it was waiting for some other

Re: [ADMIN] cost of empty fields

2005-04-20 Thread Enrico Weigelt
* Jim C. Nasby <[EMAIL PROTECTED]> wrote: > If you setup rules on the view and just have the application select, > insert, update, and delete from the view instead of the raw tables you > won't need to change your application at all. Though you do need to be > aware that you can't easily enforce un

Re: [ADMIN] cost of empty fields

2005-04-20 Thread Jim C. Nasby
On Thu, Apr 21, 2005 at 04:19:02AM +0200, Enrico Weigelt wrote: > * Jim C. Nasby <[EMAIL PROTECTED]> wrote: > > If you setup rules on the view and just have the application select, > > insert, update, and delete from the view instead of the raw tables you > > won't need to change your application a