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
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,
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
19 matches
Mail list logo
