:
El 11/08/15 a las 17:19, Felipe Gasper escribió:
Hello all,
We are noticing what appears to be a significant difference between
PostgreSQL 9.x and 8.4. Not having found documentation that would point
us in the direction of a good solution, I thought I’d post our issue here.
On CentOS 6 we
On 11 Aug 2015 6:30 PM, Martín Marqués wrote:
local samerole allmd5
host samerole all 127.0.0.200 255.255.255.255 pam
pamservice=postgresql_cpses
host samerole all 127.0.0.1 255.255.255.255 md5
local all postgresmd5
host all postgres 127.0.0.1 255.255.255.255 md5
On 11 Aug 2015 5:56 PM, Adrian Klaver wrote:
On 08/11/2015 01:19 PM, Felipe Gasper wrote:
Hello all,
We are noticing what appears to be a significant difference between
PostgreSQL 9.x and 8.4. Not having found documentation that would point
us in the direction of a good solution, I
eing any 127.0.0.0/8 address as 127.0.0.1. Could you please shed
some light on the issue or point us in the right direction on how to
make the 9.2.13 configuration function as the 8.4.20 configuration does?
Thank you!
-Felipe Gasper
Houston, TX
--
Sent via pgsql-general mailing
On 2/10/15 12:57 PM, David G Johnston wrote:
Felipe Gasper wrote
Is there a quick way to reset a PgSQL cluster to its pristine
state--i.e., to what initdb gives but preserving configuration
customizations?
Not that I am aware of.
If you describe your use-case then meaningful suggestions
Hello,
Is there a quick way to reset a PgSQL cluster to its pristine
state--i.e., to what initdb gives but preserving configuration
customizations?
Thank you!
-FG
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
On 6 Feb 2015 4:51 PM, David G Johnston wrote:
On Fri, Feb 6, 2015 at 3:41 PM, Felipe Gasper [via PostgreSQL] <[hidden
email] >wrote:
So, this works when I do it manually, but not when I script it.
Is it possible that this change doesn’t take effect immediately? Is
there a
On 6 Feb 2015 4:31 PM, Felipe Gasper wrote:
On 6 Feb 2015 4:21 PM, Jerry Sievers wrote:
David G Johnston writes:
On Fri, Feb 6, 2015 at 2:29 PM, Felipe Gasper [via PostgreSQL]
<[hidden email]> wrote:
On 6 Feb 2015 3:15 PM, David G Johnston wrote:
> Felipe Gas
On 6 Feb 2015 4:21 PM, Jerry Sievers wrote:
David G Johnston writes:
On Fri, Feb 6, 2015 at 2:29 PM, Felipe Gasper [via PostgreSQL] <[hidden email]>
wrote:
On 6 Feb 2015 3:15 PM, David G Johnston wrote:
> Felipe Gasper wrote
>> Hello,
>>
On 6 Feb 2015 4:04 PM, Michael Nolan wrote:
Encrypted passwords are kept in the pg_shadow file and should start with 'md5'.
Just save a copy of the encrypted password for that user and when you
want to re-enable that user do:
alter user xxx encrypted password 'md5';
I have tested this
On 6 Feb 2015 3:24 PM, David G Johnston wrote:
On Fri, Feb 6, 2015 at 2:22 PM, Michael Nolan [via PostgreSQL] <[hidden
email] >wrote:
Might not do what you want, but I just change the password.
How do you do that and re-enable using the previous password?
Is there no way to “sync up” f
On 6 Feb 2015 3:15 PM, David G Johnston wrote:
Felipe Gasper wrote
Hello,
Is there a way to temporarily suspend a user account?
I would prefer not to revoke login privileges since that will break
things that mine pg_users and pg_shadow.
I also am trying to find
anyone else solved this issue? Thank you!
-Felipe Gasper
Houston, TX
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 7/1/14 1:13 PM, John R Pierce wrote:
On 7/1/2014 11:08 AM, Felipe Gasper wrote:
What is the best way to list a role’s owned objects in any database?
query pg_class in each database ?
Every database on the cluster, individually, then? Is there no way to
query all databases at once
purpose (it only works on the
current database), I would still need a way to display to the API caller
which objects were reassigned.
Oh, and this preferably needs to work all the way back to PostgreSQL
8.1. :-<
Any ideas?
Thanks!
-Felipe Gasper
Houston, TX
--
Sent
On 17.11.13 2:56 AM, Luca Ferrari wrote:
On Sat, Nov 16, 2013 at 1:19 AM, Felipe Gasper wrote:
Hi all,
How can I retrieve:
1) each role’s privileges on a given DB
Do you mean pg_database.datacl?
http://www.postgresql.org/docs/current/static/catalog-pg-database.html
2) which
therole TO theuser”, how can I list all of
the users that can take on “therole”?
3) which roles a given user can access
For example, if I do: “GRANT therole TO theuser”, how can I list all of
the roles that “theuser” can take on?
Thanks!
-Felipe Gasper
Houston, TX, USA
--
Sent via pgsql
17 matches
Mail list logo
