I turned on log_connections and that is indeed the problem. Looks like it's my
software and not pg.
Thanks all!
Cheers,
Ovid
--
IT consulting, training, international recruiting
http://www.allaroundtheworld.fr/.
Buy my book! - http://bit.ly/beginning_perl
Live and work overseas - http://
select current_user;
On Thu, Jan 30, 2014 at 3:53 PM, Adrian Klaver wrote:
> On 01/30/2014 06:13 AM, Ovid wrote:
>
>> First: CREATE ROLE and CREATE DATABASE;
>>>
>>
>> After: CREATE TABLEs;
>>>
>>
>> Last: GRANT SELECT,INSERT,UPDATE and DELETE.
>>>
>>
>> OK, I dropped the database. Since I hav
Adrian Klaver writes:
> I would tend to go with Raymond, are you sure about the user you are
> connecting as?
That's my thought as well.
> It would be helpful to tail the Postgres log and see what the connection
> info is.
Note you will need to turn on "log_connections" to have the relevant
i
On 01/30/2014 06:13 AM, Ovid wrote:
First: CREATE ROLE and CREATE DATABASE;
After: CREATE TABLEs;
Last: GRANT SELECT,INSERT,UPDATE and DELETE.
OK, I dropped the database. Since I have the user already created, I
recreated the database. Then I created all of the tables. Then I did this:
p
On 30/01/2014 14:13, Ovid wrote:
>> First: CREATE ROLE and CREATE DATABASE;
>
>> After: CREATE TABLEs;
>
>> Last: GRANT SELECT,INSERT,UPDATE and DELETE.
>
> OK, I dropped the database. Since I have the user already created, I
> recreated the database. Then I created all of the tables. Then I did
> First: CREATE ROLE and CREATE DATABASE;
> After: CREATE TABLEs;
> Last: GRANT SELECT,INSERT,UPDATE and DELETE.
OK, I dropped the database. Since I have the user already created, I recreated
the database. Then I created all of the tables. Then I did this:
postgres=# GRANT SELECT ON ALL TABL
Hello,
2014-01-30 Ovid
> And in the above, by "veure_user" in the pg_hba.conf, I obviously meant "
> some_user".
>
> Cheers,
> Ovid
> --
> IT consulting, training, international recruiting
>http://www.allaroundtheworld.fr/.
> Buy my book! - http://bit.ly/beginning_perl
> Live and work o
And in the above, by "veure_user" in the pg_hba.conf, I obviously meant
"some_user".
Cheers,
Ovid
--
IT consulting, training, international recruiting
http://www.allaroundtheworld.fr/.
Buy my book! - http://bit.ly/beginning_perl
Live and work overseas - http://www.overseas-exile.com/
O
Hi all,
Struggling to figure out what I'm doing wrong with postgresql 9.1.11.
I've created a user and database like this:
CREATE USER some_user WITH ENCRYPTED PASSWORD '...';
CREATE DATABASE mydatabase ENCODING 'UTF8' OWNER some_user TEMPLATE
template0;
GRANT ALL PRIVILEGES ON ALL
And many others errors when xsome user connect to database x, schema
xxx. PG 8.4.
Problems started about same time as search_path has SET.
search_path has reset, but did'nt help.
ALTER DATABASE x SET search_path=some, public;
-- xxx wasn't in that list
ALTER DATABASE x RESET search_path; - has
Jukka Inkeri writes:
> Only one group has this priviledge problem, xgroup.
> pg_log after tried to connect:
> 2012-08-25 11:39:36 EEST ERROR: permission denied for relation pg_database
> 2012-08-25 11:39:36 EEST STATEMENT: SET DateStyle=ISO;
> SELECT oid, pg_encoding_to_char(encoding) AS e
And many others errors when xsome user connect to database x, schema
xxx. PG 8.4.
Problems started about same time as search_path has SET.
search_path has reset, but did'nt help.
ALTER DATABASE x SET search_path=some, public;
-- xxx wasn't in that list
ALTER DATABASE x RESET search_path; - has
Armon Ezra <[EMAIL PROTECTED]> schrieb:
> while browsing a web site (which I am trying to handle), I get an error
> message like this:
> *" Warning*: pg_query() [function.pg-query]: Query failed: ERROR:
> permission denied for relation -table name- in... on line 45 "
> I believe it ha
while browsing a web site (which I am trying to handle), I get an
error message like this:
*" Warning*: pg_query() [function.pg-query]: Query failed: ERROR:
permission denied for relation -table name- in... on line 45 "
I believe it has a connection to upgrading to postgresql8 , but I
14 matches
Mail list logo
