Re: Local authentication/security - Mailing list pgsql-general

From Lange Marcus
Subject Re: Local authentication/security
Date
Msg-id 6F2815FEE7F896458CDE99423F396992012FC817@corpappl002.corp.saab.se
Whole thread Raw
In response to Re: Local authentication/security  (Richard Huxton <dev@archonet.com>)
Responses Re: Local authentication/security  (Richard Huxton <dev@archonet.com>)
List pgsql-general
> > Is there a way to assure that the database does not get
> stored on disk
> > ? If my program, everytime it starts, would create or build up the
> > database could this database be kept in RAM ? Or does postgres
> > automatically create a database file or something ? Do you
> understand
> > what i mean ?
>
> You could create a ramdisk, then create the database on that.
> Of course, if you lose power then you lose your data. Check
> the manuals for details on "tablespaces" for how to have some
> DB objects in a different location.
>
> > Another question, are md5 passowords supported under windows ?
>
> Any reason why they shouldn't be?
>
> Not that it matters in your case. The password might as well
> be "password" - if they get access to the files/application,
> it's game over.

What about having some of the columns encrypted in the database ?
Will that improve things abit ?
Regards Marcus

pgsql-general by date:

Previous
From: Josh Trutwin
Date:
Subject: Re: [OT - sorta] How to extract a substring using Regex
Next
From: Markus Schiltknecht
Date:
Subject: Re: Geographic High-Availability/Replication