[GENERAL] Hot standby problems: consistent state not reached, no connection to master server.

Hello. I'm setting up hot standby slave. It recovers from wal archive files, but I can't connect to it: $ psql psql: FATAL: the database system is starting up On master: # select name,setting from pg_settings where name like 'wal_level'; name| setting ---+- wal_leve

Re: [GENERAL] Hot standby problems: consistent state not reached, no connection to master server.

On 04/12/2015 07:47 AM, Ilya Ashchepkov wrote: Hello. I'm setting up hot standby slave. It recovers from wal archive files, but I can't connect to it: $ psql psql: FATAL: the database system is starting up On master: # select name,setting from pg_settings where name like 'wal_level'; name

[GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

On Sun, 12 Apr 2015 08:10:48 -0700 Adrian Klaver wrote: > On 04/12/2015 07:47 AM, Ilya Ashchepkov wrote: > > Hello. > > > > I'm setting up hot standby slave. > > It recovers from wal archive files, but I can't connect to it: > > $ psql > > psql: FATAL: the database system is starting up > > > >

Re: [GENERAL] Benchmarking partitioning triggers and rules

On 4/8/15 4:58 PM, Tim Uckun wrote: So is there a third and even faster way of doing this? Please don't top-post. On Wed, Apr 8, 2015 at 4:08 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 04/07/2015 07:49 PM, Tim Uckun wrote: I understand that there is overhead

Re: [GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

On 04/12/2015 08:25 AM, Ilya Ashchepkov wrote: On Sun, 12 Apr 2015 08:10:48 -0700 Adrian Klaver wrote: On 04/12/2015 07:47 AM, Ilya Ashchepkov wrote: Hello. I'm setting up hot standby slave. It recovers from wal archive files, but I can't connect to it: $ psql psql: FATAL: the database syst

Re: [GENERAL] Help with slow table update

On 4/9/15 6:18 PM, Pawel Veselov wrote: Hi. I have a plpgsql procedure that updates a few similar tables. for some reason, updates on one of the tables take a lot longer the updates on the other ones. The difference is, say, 7 seconds vs. 80 milliseconds. the procedure uses cursors and record v

[GENERAL] schema or database

hi, all; I am new here. And I need some suggestion. I have many similar database to store data for every customer. Structure of database is almost the same. As I use same application to control all these data, so I can only use one database user to connect to these database. And I have no needs t

Re: [GENERAL] schema or database

On 13/04/15 11:08, Michael Cheung wrote: > hi, all; > > I am new here. And I need some suggestion. > > I have many similar database to store data for every customer. > Structure of database is almost the same. > As I use same application to control all these data, so I can only use > one database

Re: [GENERAL] schema or database

On 4/12/2015 7:20 PM, Ian Barwick wrote: If as you say access to the database is via a single application database user, it will probably make more sense to use multiple schemas rather than multiple databases. Keeping everything in one database will simplify administration (e.g. making backups -

Re: [GENERAL] schema or database

Thanks for your suggestion. I'd like to use schema as you suggest. yours, michael On Mon, 13 Apr 2015 11:20:59 +0900 Ian Barwick wrote: > On 13/04/15 11:08, Michael Cheung wrote: > > hi, all; > > > > I am new here. And I need some suggestion. > > > > I have many similar database to store data

Re: [GENERAL] schema or database

Thanks for your additional comment. It is more clear, I'd better to using schema more than using database. yours, michael On Sun, 12 Apr 2015 19:24:30 -0700 John R Pierce wrote: > On 4/12/2015 7:20 PM, Ian Barwick wrote: > > If as you say access to the database is via a single application dat

Re: [GENERAL] Limiting user from changing its own attributes

On 4/11/15 4:11 PM, Sameer Kumar wrote: Pg_settings currently has an upper bound column - though it is a view and that value cannot be changed that I know of. I guess that upper bound column is more of the limit that is imposed by system which you can have for a parameter i.e. the syste

Re: [GENERAL] Limiting user from changing its own attributes

On Mon, 13 Apr 2015 11:35 Jim Nasby wrote: On 4/11/15 4:11 PM, Sameer Kumar wrote: > Pg_settings currently has an upper bound column - though it is a > view and that value cannot be changed that I know of. > > > I guess that upper bound column is more of the limit that is imposed by > sy

Re: [GENERAL] Limiting user from changing its own attributes

On 4/12/15 11:55 PM, Sameer Kumar wrote: On Mon, 13 Apr 2015 11:35 Jim Nasby mailto:jim.na...@bluetreble.com>> wrote: On 4/11/15 4:11 PM, Sameer Kumar wrote: > Pg_settings currently has an upper bound column - though it is a > view and that value cannot be changed that I k

Re: [GENERAL] Limiting user from changing its own attributes

On Mon, Apr 13, 2015 at 1:03 PM Jim Nasby wrote: > On 4/12/15 11:55 PM, Sameer Kumar wrote: > > > > On Mon, 13 Apr 2015 11:35 Jim Nasby > > wrote: > > > > On 4/11/15 4:11 PM, Sameer Kumar wrote: > > > Pg_settings currently has an upper bound column -