On 3/8/19 9:20 PM, Tom Lane wrote:
Bruce Momjian writes:
On Sat, Mar 9, 2019 at 02:13:57AM +, Julie Nishimura wrote:
Is there a way to reconstruct DDL for creation of existing databases? For
example, I need to create dev environment for some (not all) of our existing
databases, and I woul
Bruce Momjian writes:
> On Sat, Mar 9, 2019 at 02:13:57AM +, Julie Nishimura wrote:
>> Is there a way to reconstruct DDL for creation of existing databases? For
>> example, I need to create dev environment for some (not all) of our existing
>> databases, and I would like to keep the same enco
On Sat, Mar 9, 2019 at 02:13:57AM +, Julie Nishimura wrote:
> Hello psql friends,
> Is there a way to reconstruct DDL for creation of existing databases? For
> example, I need to create dev environment for some (not all) of our existing
> databases, and I would like to keep the same encoding,
Hello psql friends,
Is there a way to reconstruct DDL for creation of existing databases? For
example, I need to create dev environment for some (not all) of our existing
databases, and I would like to keep the same encoding, connection limit (if
anything was specified), etc. Is there a way to c
I am building a multi-tenant deployment with multiple database - 1 tenant per
database.
I would like to be able to dedicate specific temp tablespace to a specific
database or user/schemas.
I understand how to define temp_tablespace in postgresql.conf.
I can't find anything in the documentatio
For now I do not see the strong reason, but i inherited this project from
other developers,
Originally there was MongoDB and structure was more complex, having SNMP
like nested tables with OID.Instance1.Instance2.instance3 and in JSON it
looked like:
{
"1.3.6.1.4.1..3.10.2.2.25.4.1.43.1": {
Is there a reason not to use a relational model instead of json(b) here? I
think that is in fact considered best practice.
On Fri, 8 Mar 2019 at 15:40, Alexandru Lazarev
wrote:
> I am working on product managing and monitoring Network (NMS-like
> products).
>
> Product manages configuration of n
I am working on product managing and monitoring Network (NMS-like products).
Product manages configuration of network devices, for now each device has
stored its configuration in simple table - this was the original design.
CREATE TABLE public.configuration(
id integer NOT NULL,
config json N
Il 07/03/2019 21:19, Arjun Ranade ha
scritto:
I'm looking at pgbouncer and it does most of what I need.
I'm wondering about clients connecting via pgadmin, is there a
way for users using pgadmin or another tool to see all the
