Re: [GENERAL] permission problem

2014-07-11 Thread John R Pierce
On 7/11/2014 11:37 PM, Roelof Wobben wrote: First I see this error ; role "roelof" does not exist. I solved it by doing : sudo -u postgres createuser roelof but now when I make the database by doing rake db:create I see this error ; PG::InsufficientPrivilege: ERROR: permission denied to cre

[GENERAL] permission problem

2014-07-11 Thread Roelof Wobben
Hello, I try to use postgresql with Ruby on Rails. First I see this error ; role "roelof" does not exist. I solved it by doing : sudo -u postgres createuser roelof but now when I make the database by doing rake db:create I see this error ; PG::InsufficientPrivilege: ERROR: permission denied

[GENERAL] debugging with gdb

2014-07-11 Thread Ravi Kiran
Hi, I am facing some problem with gdb for the past few days. I want to debug nestloop.c in postgresql , so I followed the below steps. I followed the steps given in the below for collecting the stack trace. https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-11 Thread Craig Ringer
On 07/12/2014 02:42 AM, Martin Gudmundsson wrote: > Hi all! > I was wondering if there are any specific load balancing/failover > functionality planned for client drivers connection to a BDR group. In my > case the jdbc driver, but could be relevant for other drivers as well. PgJDBC actually alr

Re: [GENERAL] Synonym/thesaurus dictionaries for FTS

2014-07-11 Thread Sergey Konoplev
FYI On Wed, Jul 9, 2014 at 4:58 PM, Sergey Konoplev wrote: > Are there any publicly available synonym/thesaurus dictionaries for FTS? So, I've found several worth attention open projects providing synonyms and thesaurus dictionaries. http://archive.services.openoffice.org/pub/mirror/OpenOffice.

Re: [GENERAL] index contains unexpected zero page at block error

2014-07-11 Thread François Beausoleil
Le 2014-07-04 à 14:42, François Beausoleil a écrit : > Hi, > > I ran a query on the slave and got the error message in the subject. I > rebuilt the slave two days ago on ZFS (with compression). I’m wondering how > that unexpected zero page happened in the first place. > > Master: > Linux kal

[GENERAL] Bi-Directional replication client awareness

2014-07-11 Thread Martin Gudmundsson
Hi all! I was wondering if there are any specific load balancing/failover functionality planned for client drivers connection to a BDR group. In my case the jdbc driver, but could be relevant for other drivers as well. Or is the long term plan that we need we need to rely on middleware like pgpo

Re: [GENERAL] Windows Installation User account - Correct database for us

2014-07-11 Thread Igor Neyman
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Don Brown Sent: Thursday, July 10, 2014 7:56 PM To: pgsql-general@postgresql.org Subject: [GENERAL] Windows Installation User account - Correct database for us Hello We are writing a small applicati

[GENERAL] Windows Installation User account - Correct database for us

2014-07-11 Thread Don Brown
Hello We are writing a small application and we are trying to determine if PostgreSQL is the right database for us. The application at this stage is only for a single user and commonly for persons with little computer expertise. When the database is installed a postgreSQL user account is creat

Re: [GENERAL] Standby Server and Barman Backup on production system

2014-07-11 Thread Francisco Olarte
Hello Sebastian: On Thu, Jul 10, 2014 at 11:23 AM, Sebastian Fiedler - Nexst4 GmbH wrote: > I use one Postgres Server as Master an an other one as Standby (WAL > archives). > I do also a daily backup of the Master Server using pg_dump. > Now there is a situation where a possible restore via "cat