Hi Tiff,
from what you say, it sounds that each user should have his or her own database.
Considering the other answers here already pointing out the difficulties, why
don't you just create a database for each user with the same name as the
username and grant him or her access to it.
So, basic
On Friday, March 6, 2020, David G. Johnston
wrote:
> On Fri, Mar 6, 2020 at 4:28 PM Tiffany Thang
> wrote:
>
>> Hi,
>> Is there a way in PostgreSQL 12 to restrict user to creating a database
>> with a specific database name?
>>
>>
>
>> You could just have them log into an admin database and run
On Fri, Mar 6, 2020 at 4:28 PM Tiffany Thang wrote:
> Hi,
> Is there a way in PostgreSQL 12 to restrict user to creating a database
> with a specific database name?
>
> For example, userA can only create a database with a name called mydb. Any
> other names would generate an error.
>
> If that is
Hi,
Is there a way in PostgreSQL 12 to restrict user to creating a database
with a specific database name?
For example, userA can only create a database with a name called mydb. Any
other names would generate an error.
If that is not possible, will it be possible then to limit userA to
creating o
Hey Ted,
libpq has no such a facility. If you're on C++ you may want to use Pgfe
library to work with the database arrays easy.
On Fri, 6 Mar 2020, 22:11 Ted Toth, wrote:
> I've got so C code that interacting with a table containing a field of
> type text[]. Strings I've got to put in the array
I've got so C code that interacting with a table containing a field of type
text[]. Strings I've got to put in the array may be unicode and or contain
single or double quotes etc ... What's the best way to escape these
strings?
Ted
Hi,
On 2020-02-27 10:52:36 -0500, Tom Lane wrote:
> FWIW, I can't immediately think of a reason this would cause a problem,
> at least not on 9.4 and up which use MVCC catalog scans. If you're
> really still on 9.3 then it's notably more risky. In any case, I've
> not had any caffeine yet today,
On 3/6/20 01:25, Ron wrote:
> On 3/5/20 6:07 AM, Laurenz Albe wrote:
>> On Thu, 2020-03-05 at 07:45 +, Daulat Ram wrote:
>>> Is there any possibility/options to setup a real application clustering in
>>> Postgres as in Oracle we have a RAC feature.
>> No, and as far as I know nobody feels i
Yup, if you need true shared storage, Oracle RAC is still the only solution
out there, All the other multi-master solutions work by capturing the sql
statements themselves. And properly configured it RAC is indeed part of an
HA solution. Any time you have everything in a single data center, as yo
On 3/6/20 8:55 AM, Laurenz Albe wrote:
On Fri, 2020-03-06 at 03:25 -0600, Ron wrote:
RAC is not really a high availability solution: because of the shared
storage, it has a sibgle point of failure.
This is utter nonsense. Dual redundant storage controllers
connected to disks in RAID-10 configu
On 06/03/2020 16:14, Andrei Zhidenkov wrote:
If it's a single command you're trying to limit `SET statement_timeout TO
` should do the trick.
This will set only statement timeout but won’t work for long transactions that
contain a lot of short statements.
If you want it based on the sessi
> If it's a single command you're trying to limit `SET statement_timeout TO
> ` should do the trick.
This will set only statement timeout but won’t work for long transactions that
contain a lot of short statements.
> If you want it based on the session's cumulative statement time, off the top
On 3/5/20 6:39 PM, Mark Haylock wrote:
Hi,
We have an autovacuum process that has been running for almost 27 hours:
SELECT * FROM pg_stat_activity WHERE pid = 11731;
-[ RECORD 1 ]+---
datid| 16385
datname | database_name
pid
>
> If you have mirrored disks, and you write junk (e.g, because of
> a flaw in a fibre channel cable, something I have witnessed),
> then you have two perfectly fine copies of the junk.
>
Few years ago didn't this happen to Salesforce where a firmware bug corrupted
the Disk, resulting in corru
On 06/03/2020 14:24, Andrei Zhidenkov wrote:
Is there a way to limit a transaction lifetime in PostgreSQL? I could
use `idle_in_transaction_session_timeout` parameter but it applies only
to IDLE transactions. However, I want to rollback any transaction that
executes more than specified period
On Fri, 2020-03-06 at 11:04 +, Schmid Andreas wrote:
> I'd like to setup my database in a way that only a superuser may create
> schemas,
> then grants permission to a specific user to create tables inside this schema.
> This should work so far with GRANT CREATE ON SCHEMA ... TO user_a.
> Howe
On Fri, 2020-03-06 at 03:25 -0600, Ron wrote:
> > RAC is not really a high availability solution: because of the shared
> > storage, it has a sibgle point of failure.
>
> This is utter nonsense. Dual redundant storage controllers
> connected to disks in RAID-10 configurations have been around
Is there a way to limit a transaction lifetime in PostgreSQL? I could use
`idle_in_transaction_session_timeout` parameter but it applies only to IDLE
transactions. However, I want to rollback any transaction that executes
more than specified period of time.
--
With best regards, Andrei Zhidenkov.
I have looked at:
https://www.postgresql.org/docs/8.4/plperl-database.html
I am also comfortable querying data from tables in perl. But I do not
quite see how to get the results of a query in plperl. Here is what I
tried, and it is not working:
my $rv2 = spi_exec_query('SELECT current_user');
Hi List
I'd like to setup my database in a way that only a superuser may create
schemas, then grants permission to a specific user to create tables inside this
schema. This should work so far with GRANT CREATE ON SCHEMA ... TO user_a.
However I want the table owner not to be the user that creat
On 3/5/20 6:07 AM, Laurenz Albe wrote:
On Thu, 2020-03-05 at 07:45 +, Daulat Ram wrote:
Is there any possibility/options to setup a real application clustering in
Postgres as in Oracle we have a RAC feature.
No, and as far as I know nobody feels interested in providing it.
RAC is a compl
On Thu, 2020-03-05 at 17:06 +, Virendra Kumar wrote:
> Failover is easy but failback is little bit tricky.
> I have implemented failback by doing following steps:
>
> 1. Start original primary which will be doing crash recovery. It should be
> designed in such a way that once it is up applica
22 matches
Mail list logo
