Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #114

Re: Using dblink and dblink-connect-u

Show all headers | View raw

On Tue, 3 May 2011 10:18:53 +0200, "Laurenz Albe" <invite@spam.to.invalid> wrote:

>Does anybody who is *not* the DBA have shell access to the postgres
>account on the server machine? If yes, you are in trouble anyway.

I am the ONLY user on the machine, whether I log in as postgres or named user accounts for the
different databases. Nobody else has access unless they break in to my address or steal my PC.

I've looked at the "trust" setting and it might be suitable - all my databases are relatively small
(< 30,000 rows of data combined, each row only limited columns) and my backups should run within a
matter of two to three minutes, possibly less. 
Most of my data is also encrypted (or will be) using my own external encryption algorithms so even
if somebody hacks in remotely there is little risk of them acquiring anything useful. Of course,
they could cause damage by overwriting my data, hence regular backups.

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar

Thread

Using dblink and dblink-connect-u gargoyle60 <gargoyle60@example.invalid> - 2011-04-05 10:35 +0100
  Re: Using dblink and dblink-connect-u "Laurenz Albe" <invite@spam.to.invalid> - 2011-05-03 10:18 +0200
    Re: Using dblink and dblink-connect-u gargoyle60 <gargoyle60@example.invalid> - 2011-05-03 20:39 +0100

csiph-web