Posted
by Adam Matan
on Server Fault
See other posts from Server Fault
or by Adam Matan
Published on 2009-08-30T14:11:05Z
Indexed on
2010/04/05
18:13 UTC
Read the original article
Hit count: 432
Hi,
Is there a one-liner that grants the SELECT permissions to a new user postgresql?
Something that would implement the following pseudo-code:
GRANT SELECT ON TABLE * TO my_new_user;
© Server Fault or respective owner
as seen on Ask Ubuntu
- Search for 'Ask Ubuntu'
I installed postgresql 9.2 from add-apt-repository ppa:pitti/postgresql using apt-get install postgresql-9.2
At the end of the install and every time I try to launch postgresql by using the following command
/etc/init.d/postgresql start
or
service postgresql start
I get this error:
Error:…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I tried install psycopg2 via pip in my virtual env, but got this error:
ld: library not found for -lpq
(full log here: http://pastebin.com/XdmGyJ4u )
I tried install postgres 9.1 from .dmg and via port,
(gksks)iMac-Alexander:~ lorddaedra$ locate libpq
/Developer/SDKs/MacOSX10.7.sdk/usr/include/libpq
/Developer/SDKs/MacOSX10…
>>> More
as seen on Super User
- Search for 'Super User'
On ubuntu 12.04, whenever I try to install a package using apt-get I'm greeted by:
The following packages have unmet dependencies:
postgresql-9.1 : Depends: postgresql-client-9.1 but it is not going to be instal
led
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a so
lution)…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Hey everyone, I am trying to install (using ports) PostgreSQL on a virtual server, running FreeBSD. My one question is this:
Which of the following should I install?
postgresql-contrib
postgresql-docs
postgresql-jdbc
postgresql-libpgeasy
postgresql-libpq++
postgresql-libpqxx
postgresql-odbc
…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
A freshly installed PostgreSQL (with configuration overwritten) won't start:
$ sudo service postgresql start
* Starting PostgreSQL 9.1 database server
* Error: could not read /etc/postgresql/9.1/main/postgresql.conf: Permission denied
Looks like it should be able to read it though:
$ ls -l postgresql…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
I am developing an application suite where users will need to connect to a server and depending on their account type they will be given some services. The server will run Linux. Can you please suggest me some user management API which I can use to develop the server program? By user management…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi guys, I'm modifying our collaboration system so it can be listed on google applications. A small issue I'm facing is the registering of user details. By default whenever someone logs into their google Apps account they pretty much are logged into the application.
For every action taken by a registered…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi guys, I'm modifying our collaboration system so it can be listed on google applications. A small issue I'm facing is the registering of user details. By default whenever someone logs into their google Apps account they pretty much are logged into the application.
For every action taken by a registered…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm new to php/mySQL and am trying to create a website which will allow users to register. In future, there will be a paid content area where content will be shown based on the payment status.
Is there a good opensource lightweight framework which takes care of the user management part? (Register…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm new to using SugarCRM. I want to have a users page that does the following:
1) allow a user to create sub-users, and each sub-user can then create additional sub users
2) display users in an expandable and collapse-able hierarchical tree structure.
3) add more attributes to each user
Does…
>>> More
