Hi Folks,
We reported a bug last month (#14119) related to receiving a permission denied
error on the pg_xlog/RECOVERYXLOG file when performing a database recovery
(PostgreSQL versions 9.2.16 and 9.2.17). The bug report was for version 9.2.16
but we also are having the same problem with 9.2.17
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
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 able to use
"pg_dump" to perform scripted backups. I've written to the site's
support services, but until now, they've not been able to help (they've
responded
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
"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
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 changed and if I check them using \z the sys
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
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 be mentioned: 'xml', 'text',
'csv', 'binary'.
Yours, Stefan
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
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.
psql (9.1.2)
CREATE EXTENSION ltree;
ERROR: permission denied to create extension "ltree"
HINT: Must be superuser to create this extension.
Why does ltree require superuser privledge? Is it dangerous and allow
circumventing server security? No mention of this in manual so it is
either documenta
Hi,
I get following error from pgAdmin base/16547/29877 Permission denied
on Windows, when opening database statistics. I almost sure how to
reproduce this error, but it only works on one database. It's mix of
following steps mainly in this order. In any way bug is not always sure,
but chance
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
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 denied for schema nms
LINE 1: SEL
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
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:
spam=> INSERT INTO permout ( site, cp, owner, descr, creat_w
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
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 GRANT
this permission (if
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
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,hulpverlener_id) VALUES
('true','45','58','864','30','22
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
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
I have checked the permission for this sequence as well as the ot
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
6:36 PM
Subject: [GENERAL] Permission denied to create database
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 func
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
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 problem?
$ createdb -U
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
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
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: Permission denied: logfile 2>&1 &
I did a chown on /usr/local/pgsql/data and am running this as postgres.
---(end of broadcast)-
"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
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 open relation 20321/20322/796354:
Permissi
Hi,
I am using Postgres-.8.0.1.
I am creating a function with ‘pltclu’ language. I have already created
database with ‘pltclu’
language. But on creation this function I am getting this error and failed to create
this function
-
ERROR: Permission denied for
Getting recurring lines in log of
ERROR: permission denied for relation logs
Is there a way to tell from which DB this error is coming from? Or even
what user?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTE
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
LS,
i'm trying to copy data into a table using a copy command using:
COPY tabelName FROM '/somewhere/somebody/datafile.txt';
I've given everybody the right to use the datafile.txt (execute, read,
write) with an incredible chmod . Still i get the message:
ERROR: COPY command, running in ba
83 matches
Mail list logo
