On 09/12/2014 02:27 AM, Iain Mott wrote:
Thanks Tom and everyone that replied. Since my last email my service
provider managed to solve the problem on my main database. I looked at
the schemas listed in phpPgAdmin on this database before it was fixed
and there were two main schemas listed, "publi
Thanks Tom and everyone that replied. Since my last email my service
provider managed to solve the problem on my main database. I looked at
the schemas listed in phpPgAdmin on this database before it was fixed
and there were two main schemas listed, "public" and "topology", both
owned by postgres.
Iain Mott writes:
> Here's what happens (the important error messages are in English):
> [~]# pg_dump mydatabase > dump.sql
> pg_dump: comando SQL falhou
> pg_dump: Mensagem de erro do servidor: ERROR: permission denied for schema
> topology
> pg_dump: O comando foi: LOCK TABLE topology.topolog
On 09/11/2014 04:37 AM, Iain Mott wrote:
Thanks a lot. Here is the response to
=> SELECT postgis_full_version();
postgi
So what does pgAdmin show for ownership of the schemas?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Thanks a lot. Here is the response to
=> SELECT postgis_full_version();
postgi
s_full_version
Yep,
this means you are using postgis.
I don't know if you use postgis topology.
If you have a schema topology containing a topology table, then you also
have postgis_topology installed.
You can check this with this query : "SELECT postgis_full_version();"
Maybe the extensions have been created w
Thanks Rémi-C for the quick reply. By coincidence my site does involve
mapping, however I wasn't aware that the server might be using postgis
and postgis_topology. In psql when I type "\d" i get the following:
public | comentarios | tabela | myusername
public | featuredata | tabela
Hey,
if you are using postgis and postgis_topology,
there are specific backup/restore process.
Cheers,
Rémi-C
2014-09-11 12:49 GMT+02:00 Iain Mott :
> Hello,
>
> The server for my websites was recently changed and upgraded. I have ssh
> access to the server and since the upgrade I am no longer ab
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
"Pascal Tufenkji" writes:
> I am facing a weird permission problem with the views in our database.
> While the system is up and running, suddenly a certain view gets corrupted.
> When we try to query it, it returns permission denied. Although the
> permission has not been changed and if I check
On 10/31/2013 12:53 AM, Pascal Tufenkji wrote:
Hello,
I am facing a weird permission problem with the views in our database.
While the system is up and running, suddenly a certain view gets
corrupted. When we try to query it, it returns “permission denied”.
Although the permission has not been
Hi Thomas
Works like a charm no with different file path.
2012/12/5 Tomas Vondra :
> The file is opened from a
> PostgreSQL backend process, not using your regular user.
Thanks for the hint. Did'nt think of that - and I agree with this
implementation decision.
You are referring to RTFM below: Ma
Hi,
On 5.12.2012 00:39, Stefan Keller wrote:
> Hi
>
> I'm getting an error when reading from a file_fdw table in a Windows
> environment.
> Any hints? (see below).
Well, the file clearly isn't accessible by the postgres user (or
whatever user you're using in Windows). The file is opened from a
P
On 04/12/2012 23:39, Stefan Keller wrote:
> Hi
>
> I'm getting an error when reading from a file_fdw table in a Windows
> environment.
> Any hints? (see below).
>
> And http://www.postgresql.org/docs/9.1/static/file-fdw.html is not
> really verbose :->
> At least following format options should b
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
On Wed, Mar 14, 2012 at 9:28 PM, krz...@gmail.com wrote:
> Ok, but can someone comment, document something on security of
> installing extensions for normal users? Does allowing access to
> extension provides a way to circumvent security model? If not why
> can't it be allowed for user installatio
Ok, but can someone comment, document something on security of
installing extensions for normal users? Does allowing access to
extension provides a way to circumvent security model? If not why
can't it be allowed for user installations (provided that extension
was previously allowed in some conf fi
On Sat, Mar 10, 2012 at 7:57 AM, krz...@gmail.com wrote:
> Why does ltree require superuser privledge? Is it dangerous and allow
CREATE EXTENSION must be run by superusers only.
> circumventing server security? No mention of this in manual so it is
There is a mention here http://www.postgresql.
Chris Young writes:
> Greetings,
> I'm trying to perform the following query, but receive a perplexing error,
> even as superuser (postgres):
> umdb_db=# insert into mainview_teststatusevent
> (timestamp,host_id,test_id,old_status_id,new_status_id) values(now(),
> 726,4,6,1);
> ERROR: permission
Could it be triggering a function that is defined with "SECURITY
DEFINER" and the definer of the function does not have the right
permissions?
On Thu, May 5, 2011 at 4:03 AM, Chris Young wrote:
> Greetings,
> I'm trying to perform the following query, but receive a perplexing error,
> even as sup
Apologies, I have already solved this.
I forgot to grant usage on schema nms to foo; where foo is the owner of
mainview_teststatusevent.
Cheers,
Chris
On Thu, May 5, 2011 at 7:03 PM, Chris Young wrote:
> Greetings,
>
> I'm trying to perform the following query, but receive a perplexing error,
On Monday, February 28, 2011 9:15:27 am Tom Lane wrote:
> Adrian Klaver writes:
> > I understand, yet I don't:) Seems I have a misconception of the the
> > FOREIGN KEY process. The error was on the query below, which I am
> > taking is the query you refer to above. To me it looks like a look up
>
Adrian Klaver writes:
> I understand, yet I don't:) Seems I have a misconception of the the
> FOREIGN KEY process. The error was on the query below, which I am
> taking is the query you refer to above. To me it looks like a look up
> from the referencing(permout) table to the referenced(out2cp) on
On Monday, February 28, 2011 8:17:07 am Tom Lane wrote:
> Adrian Klaver writes:
> > On Monday, February 28, 2011 8:02:53 am Tom Lane wrote:
> >> Right. But actually, that query will be run with the permissions of the
> >> owner of the table, so it's that user (not necessarily the one doing the
>
On 28.2.2011 17:02, Tom Lane wrote:
you don't have permissions to verify the FK constraint. the query you
see in the error is exactly this test.
Right. But actually, that query will be run with the permissions of the
owner of the table, so it's that user (not necessarily the one doing the
INS
Adrian Klaver writes:
> On Monday, February 28, 2011 8:02:53 am Tom Lane wrote:
>> Right. But actually, that query will be run with the permissions of the
>> owner of the table, so it's that user (not necessarily the one doing the
>> INSERT) who lacks permissions.
> The OP listed the permissions
On Monday, February 28, 2011 8:02:53 am Tom Lane wrote:
> Vick Khera writes:
> > On Mon, Feb 28, 2011 at 9:37 AM, Borek Lupomesky wrote:
> >>"permout_site_fkey" FOREIGN KEY (site, cp) REFERENCES out2cp(site,
> >> cp) ON DELETE CASCADE
> >
> > you don't have permissions to verify the FK const
Vick Khera writes:
> On Mon, Feb 28, 2011 at 9:37 AM, Borek Lupomesky wrote:
>> "permout_site_fkey" FOREIGN KEY (site, cp) REFERENCES out2cp(site, cp) ON
>> DELETE CASCADE
> you don't have permissions to verify the FK constraint. the query you
> see in the error is exactly this test.
Right.
On Monday, February 28, 2011 6:37:51 am Borek Lupomesky wrote:
> Hello,
>
> I have a database app that worked fine until we reinstalled the
> server with the related DB dump and restore. Most of the stuff works
> fine after the reinstall, but one particular insert gives very cryptic
> (for me)
On Feb 28, 2011, at 8:07 PM, Borek Lupomesky wrote:
> spam=> INSERT INTO permout ( site, cp, owner, descr, creat_who ) VALUES (
> 'vin', '3035.1', 'borelupo', 'test', 'borelupo' );
> ERROR: permission denied for relation out2cp
> CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."out2cp" x W
In response to Rob Sargent :
> On 02/28/2011 07:37 AM, Borek Lupomesky wrote:
> > Hello,
> >
> >I have a database app that worked fine until we reinstalled the
> > server with the related DB dump and restore. Most of the stuff works
> > fine after the reinstall, but one particular insert give
On Mon, Feb 28, 2011 at 9:37 AM, Borek Lupomesky wrote:
> "permout_site_fkey" FOREIGN KEY (site, cp) REFERENCES out2cp(site, cp) ON
> DELETE CASCADE
>
you don't have permissions to verify the FK constraint. the query you
see in the error is exactly this test.
--
Sent via pgsql-general mailin
On 02/28/2011 07:37 AM, Borek Lupomesky wrote:
> Hello,
>
>I have a database app that worked fine until we reinstalled the
> server with the related DB dump and restore. Most of the stuff works
> fine after the reinstall, but one particular insert gives very cryptic
> (for me) message:
>
> sp
On Tuesday, February 08, 2011 2:44:51 pm Mike Christensen wrote:
> >> Here's the error:
> >>
> >> pg_dump: SQL command failed
> >> pg_dump: Error message from server: ERROR: permission denied for
> >> relation pantryitems
> >> pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHAR
On 02/08/11 2:44 PM, Mike Christensen wrote:
Here's the error:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: permission denied for
relation pantryitems
pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE
MODE
Does the user need to be a superuser, or
>> Here's the error:
>>
>> pg_dump: SQL command failed
>> pg_dump: Error message from server: ERROR: permission denied for
>> relation pantryitems
>> pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE
>> MODE
>>
>> Does the user need to be a superuser, or is there some way to
On 02/08/2011 10:57 AM, Mike Christensen wrote:
Here's the error:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: permission denied for
relation pantryitems
pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE MODE
Does the user need to be a superuser,
2011/2/8, Mike Christensen :
> Here's the error:
>
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: permission denied for
> relation pantryitems
> pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE MODE
>
> Does the user need to be a superuser, or is
Tom Lane <[EMAIL PROTECTED]> writes:
> jef peeraer <[EMAIL PROTECTED]> writes:
>> Tom Lane schreef:
>>> That's a foreign-key check, which is supposed to be done as the owner of
>>> the table. You did not show us who owns table clienten, but I think
>>> that role must be missing the intended(?) me
Tom Lane schreef:
jef peeraer <[EMAIL PROTECTED]> writes:
Tom Lane schreef:
That's a foreign-key check, which is supposed to be done as the owner of
the table. You did not show us who owns table clienten, but I think
that role must be missing the intended(?) membership in deterp_group.
regi
jef peeraer <[EMAIL PROTECTED]> writes:
> Tom Lane schreef:
>> That's a foreign-key check, which is supposed to be done as the owner of
>> the table. You did not show us who owns table clienten, but I think
>> that role must be missing the intended(?) membership in deterp_group.
> registratie=# \
Tom Lane schreef:
jef peeraer <[EMAIL PROTECTED]> writes:
i get this when i try to insert a record into a table. all permissions /
privileges seems ok, but probably i missed something. i am running a
8.1.3 on linux.
registratie=> INSERT INTO clienten
(anoniem,geslacht,leeftijd,origine,team_i
jef peeraer <[EMAIL PROTECTED]> writes:
> i get this when i try to insert a record into a table. all permissions /
> privileges seems ok, but probably i missed something. i am running a
> 8.1.3 on linux.
> registratie=> INSERT INTO clienten
> (anoniem,geslacht,leeftijd,origine,team_id,hulpverle
On May 31, 2007, at 14:53 , Hackenberg, Rick wrote:
I am currently having a problem with an application that has been
working fine for the past few months. Whenever I try to add a new
entry into a table I receive the following message:
ERROR: permission denied for sequnce contractid
Please
Richard Huxton wrote:
Kevin Murphy wrote:
Sleep deprived and surely doing something stupid here; I can't seem
to confer the ability to create databases on a regular user.
As a superuser: ALTER USER joe CREATEDB
Thanks, Richard and others who replied. I don't have to deal with
permissions very
>
> $ sudo -u postgres psql -c "grant all on tablespace pg_default to joe"
> Password:
> GRANT
>
> $ createdb -U joe joejunkdb
> createdb: database creation failed: ERROR: permission denied to create
> database
>
How about ALTER ROLE joe CREATEDB
Regards
MP
---(end of
Can u tell us what are the role privilages granted to user "joe"
May be you r missing with the create database privilage to user joe
With Regards
Ashish
- Original Message -
From: "Kevin Murphy" <[EMAIL PROTECTED]>
To:
Sent: Friday, May 04, 2007 6:36 PM
Subject: [GENERAL] Permiss
Kevin Murphy wrote:
Sleep deprived and surely doing something stupid here; I can't seem to
confer the ability to create databases on a regular user. I always get
"permission denied to create database". One note: template1 has had
some C functions added to it. Could that be related to the pro
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
Check where you are executing this.the user postgres does not have
permission to write logfile in your current directory
Victor Escobar wrote:
Hello,
I'm getting the following error when I do this step:
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
Exit 1: Perm
"Nik" <[EMAIL PROTECTED]> writes:
> I have PostgreSQL 8.0.6 running on Windows 2003 Server.
> A few days ago I noticed that my logs are getting filled pretty fast.
> When I checked the issue, I noticed that every one second I get the
> same error as follows:
> 2006-01-17 05:07:38 ERROR: could not
Hello Tom,
Tom Lane wrote:
> Jose Manuel Lorenzo Lopez <[EMAIL PROTECTED]> writes:
> > I created a table bdf_users as admin user 'postgres' and granted insert
> > access for this table to public.
> > Now I want to insert a line as user 'jose' (That's me!) and got the
> > following message:
> >
maybe the directory '.../somebody' does not have read permission (700?)
krishna
-Original Message-
From: Adam Ruth [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 10, 2000 9:54 AM
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Permission denied while importing data from a
fi
I've gotten that message before when users couldn't read the directory the
file is in.
--
Adam Ruth
InterCation, Inc.
www.intercation.com
"Felix Slager" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> LS,
>
> i'm trying to copy data into a table using a copy co
Try moving the file into /tmp and seeing if that works. Sometimes you run
into problems with having permissiosn on the file, but not all of the
directories before it. You must have execute permissions on all parent
directories in order to access a file in one of those dirs. The file will
o
62 matches
Mail list logo
