472,119 Members | 1,812 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

permission errors for set authority and schema public

CSN
I upgraded to 7.4 a few days ago and am getting these
errors when importing dumps: "permission denied to set
session authority" and "permission denied for schema
public". Not all of the dump is imported successfully.
Are these errors due to new features in 7.4? Do I need
to add more permissions for users?

__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #1
1 1923
CSN writes:
I upgraded to 7.4 a few days ago and am getting these
errors when importing dumps: "permission denied to set
session authority" and "permission denied for schema
public". Not all of the dump is imported successfully.


Looks like you need to restore as superuser.

--
Peter Eisentraut pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Russ | last post: by
5 posts views Thread by Geoff | last post: by
1 post views Thread by Kapten Haddock | last post: by
1 post views Thread by Mr.KisS | last post: by
3 posts views Thread by Chris Skaryd | last post: by
reply views Thread by robpimentel | last post: by
reply views Thread by beachboy | last post: by
1 post views Thread by akkha1234 | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.