On 11/03/2012 12:17 PM, Kevin Burton wrote:
> I was not aware of the login option. That is probably the solution. Thank you.
You can ALTER the user to add the LOGIN right, or just DROP it and
re-CREATE it again.
CREATE USER is shorthand for CREATE ROLE ... LOGIN
--
Craig Ringer
--
Sent via pgs
I was not aware of the login option. That is probably the solution. Thank you.
On Nov 2, 2012, at 10:43 PM, Craig Ringer wrote:
> On 11/01/2012 11:46 PM, Kevin Burton wrote:
>> Now I get psql: FATAL: role "kevin" is not permitted to log in
> Did you perhaps CREATE ROLE without the LOGIN option?
On 11/01/2012 10:40 PM, paris strikos wrote:
> Hello Team,
> I'm working on a project that uses PostgreSQL 8.3. We are
> planning a Java 7 and I would like to ask If we can use same vesion or
> should we upgarde to the latest? Thanks in advance!
You need to upgrade PostgreSQL. However, you
On 11/01/2012 11:46 PM, Kevin Burton wrote:
> Now I get psql: FATAL: role "kevin" is not permitted to log in
Did you perhaps CREATE ROLE without the LOGIN option?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://w
I'm running into this bug fixed a few days after 9.2.1 was released:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d2292f6405670e1fdac13998f87b4348c71fb9e6
Anyone know when 9.2.2 will go out?
Thanks,
Joe
Le jeudi 01 novembre 2012 à 16:49 -0500, Kevin Burton a écrit :
> I watched while the OS was installed and it looked like postgres was
> installed but the Ubuntu package apparently didn’t install it all or
> it didn’t install it correctly.
>
to list the postgresql related packages installed on
Would it be possible for a long running select query on a standby to prevent the
standby from sending status updates? This seemed to occur and consequently the
master broke the connection:
### Master:
2012-10-31 00:56:44 UTC replicator 5057 192.168.1.20(45690) database
[[unknown]] LOG:
On Thu, Nov 1, 2012 at 1:21 AM, Christian Hammers wrote:
> Hello
>
> I run two PostgreSQL servers in a master-slave setup and set
> wal_keep_segments=1000 on the master to allow long downtimes on the slave.
>
> Meanwhile the disk got fuller than I estimated and I changed the config
> to wal_keep_s
On 11/02/2012 03:08 AM, Alban Hertroys wrote:
150M database transactions a day sounds excessive, is there no way to
reduce that number?
I wish. 150M is actually a conservative estimate. In fact, we average
141M, but have been as high as 270M. It's all market dependent.
Here's a quick look a
Hi ,
In windows we do not have SCP/RSYNC utility commands, which helps us to
send the archives to remote/slave server.
I hope the below settings will help you while setting replication ..
Primary
==
archive_command = 'copy %p \\Archive_Location\\%f'
Slave
=
trigger_file = 'C:\\.trig
On Fri, Nov 2, 2012 at 9:06 AM, expertalert wrote:
>
> From command line, is there any way to find out if the server is actually a
> slave server not master ??
>
> I am writing some script, so for sanity check purpose , i need to know if
> the server the server i am on , its actually slave
>
> t
>From command line, is there any way to find out if the server is actually a
slave server not master ??
I am writing some script, so for sanity check purpose , i need to know if
the server the server i am on , its actually slave
thanks for your help.
--
View this message in context:
http
On 1 Nov 2012, at 17:44, Shaun Thomas wrote:
> On 11/01/2012 11:40 AM, Alban Hertroys wrote:
>
>> Instead of attempting to postpone freeze until beyond the life
>> expectancy of our universe, what you probably should have done is
>> vacuum more often so that vacuum has less work to do.
>
> More
On 11/02/12 12:53 AM, raghu ram wrote:
Can you please tell me , how to set up replication in win7,
without slony tool..
Below URL provides a configuration steps of Slony Replication on
Windows Operating System:
http://www.mokisystems.com/blog/setting-up-slony-on-windows/
he asked
On 11/02/12 12:33 AM, Vishalakshi Navaneethakrishnan wrote:
Can you please tell me , how to set up replication in win7, without
slony tool..
step 1) upgrade to postgresql 9.x ppreferably 9.1 or 9.2
step 2) implement streaming replication per the postgres documentation
windows will be a min
On Fri, Nov 2, 2012 at 1:03 PM, Vishalakshi Navaneethakrishnan <
nvishalak...@sirahu.com> wrote:
> Hi all,
>
> Can you please tell me , how to set up replication in win7, without slony
> tool..
>
>
Below URL provides a configuration steps of Slony Replication on Windows
Operating System:
http://w
Hi all,
Can you please tell me , how to set up replication in win7, without slony
tool..
--
Best Regards,
Vishalakshi.N
17 matches
Mail list logo
