Re: [ADMIN] Data split -- Creating a copy of database without outage

2012-05-29 Thread Haifeng Liu
Why not use a partitioned table? You can write a trigger to control which partition the coming data should be inserted. Regards, Liu Haifeng Home: http://liuhaifeng.com On May 30, 2012, at 4:13 AM, Igor Shmain wrote: > Can you please help with advice? > > I need to design a solution fo

[ADMIN] Data split -- Creating a copy of database without outage

2012-05-29 Thread Igor Shmain
Can you please help with advice? I need to design a solution for a database which will grow and will require a horizontal split at some moment. Here is how I am planning to do it: Every record in every table has a shard number. After the database becomes too large (gets too many requests), the

Re: [ADMIN] saved passwords lost when connection fails

2012-05-29 Thread Guillaume Lelarge
On Tue, 2012-05-29 at 08:14 -0700, Steve Crawford wrote: > On 05/26/2012 12:38 PM, Michael Shapiro wrote: > > PgAdmin doesn't retain the saved passwords when a connection to a > > server fails. > > > > I'd like to request that the saved passwords be kept, even in the > > event of a failure. > > >

Re: [ADMIN] saved passwords lost when connection fails

2012-05-29 Thread Steve Crawford
On 05/26/2012 12:38 PM, Michael Shapiro wrote: PgAdmin doesn't retain the saved passwords when a connection to a server fails. I'd like to request that the saved passwords be kept, even in the event of a failure. I realize that if the failure is due to an incorrect password, there needs to