Sorry, when I said we had no trouble getting in from the command line, I meant
that I could do the following to get into database named srn_mst (after su-ing
to postgres user):
psql srn_mst
and it will get me into the database whether I have the line set to trust or
md5. And does not ask for
This is what is in our pg_hba.conf file now, and it lets us login with no
password or wrong password:
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connec
Kasia Tuszynska writes:
> If I am logged in as anyone else and try: pgsql -U postgres and use the
> password - I get the following error:
> Psql: FATAL: Ident authentication failed for user "postgers"
That's what's supposed to happen, if you're using ident authentication.
If you want to be abl
Hi Everybody,
Am running into a problem with the following scenario:
I am not able to login as the db postgres user, on
Ubuntu 10.04 (Lucid Lynx)
Postgres 9.0.4
Postgres was installed with rpm for ubuntu
The password for the postgres user was set after installation
I am able to su to the postgres
On Sep 26, 2011, at 3:16 PM, Davenport, Julie wrote:
> psql srn_mst
>
> and it will get me into the database whether I have the line set to trust or
> md5. And does not ask for a password either way (never does). This is how I
> always access the database from the command line.
Right, becau
Isabella Ghiurea wrote:
> I 'm looking to gain experience with PG 9.1 replication and want
> to attend a class which will mainly cover this topic , preferably
> live instructor and in a learning center( no web based online
> class). My first choice for location is North America
There are se
On Sep 26, 2011, at 2:19 PM, Davenport, Julie wrote:
> If I use this combination:
> local all all trust
> hostall all 127.0.0.1/32md5
> or this:
> local all all md5
> hostall all 127.0.0.1/
On Mon, 2011-09-26 at 16:06 +0530, Mridul Mathew wrote:
> Hello,
>
> I wanted to take a moment here and reach out to the community with a
> question. How does postgreSQL handle schema switching in the database? I
> have a test scenario.
>
> ##
>
> vpn2=> show search_path;
> sear
Hello Gurus,
I 'm looking to gain experience with PG 9.1 replication and want to
attend a class which will mainly cover this topic , preferably live
instructor and in a learning center( no web based online class).
My first choice for location is North America, I looked at EnterpriseDB
but th
On Sep 26, 2011, at 10:16 AM, Davenport, Julie wrote:
> We are using phpPgAdmin 4.2.3 on Redhat Linux 5 to access local postgres 8.4
> databases and some remote postgres 8.0 and 7.4 databases. If I set the
> pg_hba.conf settings to “trust” I can login to phpPgAdmin with any password
> at all
We are using phpPgAdmin 4.2.3 on Redhat Linux 5 to access local postgres 8.4
databases and some remote postgres 8.0 and 7.4 databases. If I set the
pg_hba.conf settings to "trust" I can login to phpPgAdmin with any password at
all or with no password at all. If I change the "trust" to "md5" I
Hello,
I wanted to take a moment here and reach out to the community with a
question. How does postgreSQL handle schema switching in the database? I
have a test scenario.
##
vpn2=> show search_path;
search_path
-
mridul
(1 row)
CREATE OR REPLACE PACKAGE mridul.TEST
Thanks to everyone, Tom, Joe, Scott, I will be in touch today as I move through
this.
Joe - if I need to have you log in for assistance, I am more than happy to make
that happen.
Regards,
r.b.
-Original Message-
From: Joe Conway [mailto:m...@joeconway.com]
Sent: Fri 9/23/2011 5:03 PM
13 matches
Mail list logo
