On Tue, Apr 9, 2013 at 3:05 AM, Eduardo Morras
> wrote:
> On Mon, 8 Apr 2013 10:40:16 -0500
> Shaun Thomas 'stho...@optionshouse.com');>> wrote:
>
> >
> > Anyone else?
> >
>
> If his db has low inserts/updates/deletes he can use diff between pg_dumps
> (with default -Fp) before compressing.
>
M
On 04/15/2013 07:29 PM, Carlos Mennens wrote:
I dropped both roles (Carlos & DBA) from the database and I will show
you exactly what I'm doing:
postgres=# \du
List of roles
Role name | Attributes | Member of
---+
I dropped both roles (Carlos & DBA) from the database and I will show
you exactly what I'm doing:
postgres=# \du
List of roles
Role name | Attributes | Member of
---++-
On 04/15/2013 02:42 PM, Nigel Heron wrote:
Hi,
is there a way to clear the session state of sequence values fetched by
currval(regclass)? "DISCARD ALL" doesn't seem to do it.
eg. (w/ pg 9.2.4)
test=# CREATE SEQUENCE foo_seq;
CREATE SEQUENCE
test=# SELECT nextval('foo_seq');
-[ RECORD 1 ]
nextval
Hi,
is there a way to clear the session state of sequence values fetched by
currval(regclass)? "DISCARD ALL" doesn't seem to do it.
eg. (w/ pg 9.2.4)
test=# CREATE SEQUENCE foo_seq;
CREATE SEQUENCE
test=# SELECT nextval('foo_seq');
-[ RECORD 1 ]
nextval | 1
test=# SELECT currval('foo_seq');
-[
Adrian Klaver writes:
> On 04/15/2013 09:10 AM, Carlos Mennens wrote:
>> That's the end of 'carlos' being able to login. What am I doing wrong?
> Unfortunately I do not have a 9.1.x instance handy. I tried the above on
> 9.0.x and everything worked.
Works for me on 9.1.9, too. Perhaps there is
On 04/15/2013 09:10 AM, Carlos Mennens wrote:
I'm doing this all in psql.
Example:
CREATE ROLE carlos LOGIN CREATEDB CREATE ROLE REPLICATION;
I going to assume you actually did:
CREATE ROLE carlos LOGIN CREATEDB CREATEROLE REPLICATION;
otherwise it would fail on the second CREATE ROLE.
T
I'm doing this all in psql.
Example:
CREATE ROLE carlos LOGIN CREATEDB CREATE ROLE REPLICATION;
Then set password \password carlos
Now I create the ROLE:
CREATE ROLE dba NOLOGIN;
So now I have two roles:
-carlos = user role
-dba = group role
I can login just fine as 'carlos' now with no aut
On Mon, Apr 15, 2013 at 7:30 AM, Carlos Mennens wrote:
> I can't understand what is going on with my PostgreSQL server. For
> some reason after I GRANT my role 'carlos' to the 'dba' group role, I
> lose the ability to login. I've reset the password over and over for
> 'carlos' and even reversing t
I found error in my DB - sequence for column id had value less "SELECT
max ( id ) FROM table0" (sequence throwed unique violation exception
too). I set valid value for sequence and issue was resolved.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
I can't understand what is going on with my PostgreSQL server. For
some reason after I GRANT my role 'carlos' to the 'dba' group role, I
lose the ability to login. I've reset the password over and over for
'carlos' and even reversing the grant doesn't remedy the
authentication failure. The logs are
Yuriy Rusinov wrote:
> I have to put some C-language functions onto postgresql server 9.2. These
> functions are used GSL
> software library http://www.gnu.org/software/gsl/. In Makefile for these
> functions I wrote LD_FLAGS =
> ... -lgsl, On some source-based Linux distributions such as gentoo
On Mon, Apr 15, 2013 at 01:21:55PM +0530, dinesh kumar wrote:
> Would like to request you to share your valuable inputs on this. I would
> like to know the PostgreSQL registry entries when we install it through
> apt-get/yum/rpm. I mean, when we install the EnterpriseDB PostgreSQL one
> click inst
Dear Sirs,
Apologizes, if this is a duplicate question.
Would like to request you to share your valuable inputs on this. I would
like to know the PostgreSQL registry entries when we install it through
apt-get/yum/rpm. I mean, when we install the EnterpriseDB PostgreSQL one
click installer, it cre
14 matches
Mail list logo
