Hi Ankur,
Is it doable by granting the restricted permissions?
No.
Else another option would be to store the encrypted data but it would have a
performance hit.
Yes.
That is your choice: either security or performance.
Any pointers/suggestions would be much appreciated.
http://w
**Hi, I am working for a company in Redwood City that is looking for a
DBA. It is a great opportunity to join a growing and profitable company
that is still pre-ipo!
Ray: 415-533-2626
Operational DBA*
*Immediate opportunity for a talented Operational Data Warehouse DBA to
join a team of soft
On Wed, 2009-07-01 at 16:11 -0400, Mark Steben wrote:
> Great to see the announcement of the 8.4 rollout. Quick question - is hot
> standby available or still being worked on?
It is not in 8.4. The hope is to have it for 8.5.
Joshua D. Drake
--
PostgreSQL - XMPP: [email protected]
Hello,
I need to store the sensitive data in the database and would want to allow
the data retrieval/modification only through the application. So even the
administrator of the DB should NOT be allowed to update the data directly.
Also this restriction will only be applicable to few tables of the
On Tue, Jun 30, 2009 at 11:26 PM, wrote:
> > I've backed up my DB via 'pg_dump dbname' using no options. In order to
> > restore it via psql, do I first need to drop the db instance and recreate
> > it?
> >
> > Thanks in advance for your help.
> >
> > -Mike
> >
> >
> >
> yes, you have to drop the
Hi,
my database requires 1TB of disk space, but I want to avoid RAID (e.g.
8x 300GB SAS drives in RAID 10), and use rather a 1TB SATA disk.
To avoid the "slowness" of SATA showing in queries, I want to cache
lots of the database, but I don't want to buy more than 16GB RAM.
(Budget limits).
So I'm c
Great to see the announcement of the 8.4 rollout. Quick question - is hot
standby available or still being worked on?
I see mention of it in the pgsql admin archives but I don't see it in the
documentation.
Thanks,
Mark Steben│Database Administrator│
@utoRevenueRÂ "Join the Revenue-tion"
95 As
