grants files - Search results in mailing lists
Mailing lists >> pgsql-novice >> Thread
2020-07-06 15:44:35 | Re: What's the best practice to compare the transaction with the checkpoint? (Tom Lane)
granting that shoving each toasted value into its own file is a sane design, I do not see why you'd need
Mailing lists >> pgsql-novice >> Thread
2020-01-24 12:32:31 | Read only role for backup (Tom Browder)
file for easy access. I know I can, inside Postgres, grant myself select access on an object
Mailing lists >> pgsql-novice >> Thread
2019-07-29 00:26:52 | Re: How do I upgrade psql from version 7 to be 10 in Windows 10 (Karen Goh)
file format in which you have the old database.
On Sun, Jul 28, 2019 at 8:20 PM Karen Goh
Mailing lists >> pgsql-novice >> Thread
2019-02-19 00:09:15 | Exclusive Locks on Insert into large Logging tables (Peter Neave)
file when it detects locks. From there, I’ve been able to determine that intermittently the largest tables in my database are have Exclusive Locks on them for up to 1-5 seconds (For example
Mailing lists >> pgsql-novice >> Thread
2017-11-24 20:08:10 | macOS ownership and premissions (Craig H)
files? I tried granting r/w permissions to myself, but each new log file has a permissions
Mailing lists >> pgsql-novice >> Thread
2016-10-24 16:25:32 | Securing Roles (Ryan Quinn)
grant execute on all functions in schema public to pdrwd; The steps above are based off of the Managing_rights_in_postgresql.pdf file
Mailing lists >> pgsql-novice >> Thread
2016-09-20 22:09:51 | Re: Permissions (Andre Labuschagne)
granted to specific users by the owners of the objects. It works very well. We even provide live backup apps that they can run - an app does that as well. They can copy the backed
Mailing lists >> pgsql-novice >> Thread
2015-06-30 17:54:19 | Locking issues under transaction (Stefano Mioli)
file. The processing I do, as far as PG is concerned, amounts to doing a few SELECTs (a couple per line, no joins or anything) and then an UPDATE of one existing rows (at most
Mailing lists >> pgsql-novice >> Thread
2014-09-15 10:04:33 | newbee, about a bulk loading from a cdv file (Alonso Isidoro Roman)
GRANT TrialDB=> CREATE TABLE core2door_element TrialDB-> ( TrialDB(> id serial NOT NULL, TrialDB(> key character varying(255) NOT NULL, TrialDB(> type character varying(255) NOT NULL, TrialDB(> label character varying(255) NOT NULL, TrialDB(> longitude
Mailing lists >> pgsql-novice >> Thread
2014-06-16 18:42:38 | Re: Simple commands don't work (Kevin Grittner)
file, rather than what logins had passwords within the database. That grants two permissions for that
Mailing lists >> pgsql-novice >> Thread
2014-06-12 02:11:16 | Re: Upgraded, now permission denied. (Tom Lane)
file from 8.1, look to see if there are any grant/revoke commands for schema public in it. But in any case, the fix is probably grant
Mailing lists >> pgsql-novice >> Thread
2013-09-17 18:14:03 | Re: Several problems with installation on FreeBSD - how to reinstall without loosing data (Jon Theil Nielsen)
file "pg_notify/0000" Sep 17 17:39:38 mflserver4 postgres[21006]: [25-1] DEBUG: max_safe_fds = 983, usable_fds = 1000, already_open = 7 Sep 17 17:39:38 mflserver4 postgres
Mailing lists >> pgsql-novice >> Thread >> Search in thread (4)
2013-08-15 14:07:37 | Re: sudo/access to the postres OS user (Birchall, Austen)
files, which IMHO I need in order to be able to function as a DBA - is there a preferred way in which I can be granted/gain this access other than by granting
Mailing lists >> pgsql-novice >> Thread
2013-06-17 08:50:41 | Re: Postgresql iPhone (LeoTh3o)
grant you the file is valid) -- View this message in context: http:///Postgresql-iPhone-tp3958621p5759449.html Sent from
Mailing lists >> pgsql-novice >> Thread
2013-03-27 12:44:51 | about .pgpass (kobolds)
grant without need enter password . I found the culprit is .pgpass after I alter the role password psql -d db1 -h 192.168.56.200 -U user1 psql: FATAL: password authentication failed for user "user1" password retrieved from