On 2019-11-21 07:21:10 -0800, Adrian Klaver wrote:
> On 11/21/19 6:51 AM, Laurenz Albe wrote:
> > - The different databases in a cluster are physically located in
> >the same tablespace, but they are logically strictly separated.
> >You cannot connect to one database and access another data
On 2019-11-21 08:18:21 -0600, Ron wrote:
> It appears to me that, within this one Postgres "instance", there are 2
> levels of "isolation", which are database, and schemas. Is this correct?
[...]
> If so, how does this cores pond to physical on disk storage?
>
> It corresponds not at a
On 11/21/19 6:51 AM, Laurenz Albe wrote:
On Thu, 2019-11-21 at 06:55 -0500, stan wrote:
You can use tablespaces in PostgreSQL, which are directories on a
different file system, to put your data elsewhere.
But that has very limited use-cases, and normally you don't
create a tablespace.
About i
On 11/21/19 6:51 AM, Laurenz Albe wrote:
On Thu, 2019-11-21 at 06:55 -0500, stan wrote:
You can use tablespaces in PostgreSQL, which are directories on a
different file system, to put your data elsewhere.
But that has very limited use-cases, and normally you don't
create a tablespace.
About i
On 11/21/19 8:42 AM, stan wrote:
On Thu, Nov 21, 2019 at 08:18:21AM -0600, Ron wrote:
[snip]
Yes, but ... schema in Postgres are /different/ from Oracle schema.?? In
Postgres, the CREATE SCHEMA command creates a schema, whereas CREATE USER
creates a schema in Oracle.
I am still struggling with
On Thu, 2019-11-21 at 06:55 -0500, stan wrote:
> It seems to me that I can have one Postgres "server" running listening on a
> single port on a single machine. It appears that the data files for this
> "server" are managed internally by the Postgres server instance, and I
> have no control of what
On Thu, Nov 21, 2019 at 08:18:21AM -0600, Ron wrote:
> On 11/21/19 5:55 AM, stan wrote:
> > On Wed, Nov 20, 2019 at 04:24:40PM -0600, Ron wrote:
> > > On 11/20/19 4:03 PM, stan wrote:
> > > > I am working on a fairly small application to use for managing a
> > > > companies
> > > > business.
> >
On 11/21/19 5:55 AM, stan wrote:
On Wed, Nov 20, 2019 at 04:24:40PM -0600, Ron wrote:
On 11/20/19 4:03 PM, stan wrote:
I am working on a fairly small application to use for managing a companies
business.
I have a "production" instance hosted by one of the cloud providers, and 2
other instances
On Wed, Nov 20, 2019 at 04:24:40PM -0600, Ron wrote:
> On 11/20/19 4:03 PM, stan wrote:
> > I am working on a fairly small application to use for managing a companies
> > business.
> >
> > I have a "production" instance hosted by one of the cloud providers, and 2
> > other instances. This is fairl
On 11/20/19 4:03 PM, stan wrote:
I am working on a fairly small application to use for managing a companies
business.
I have a "production" instance hosted by one of the cloud providers, and 2
other instances. This is fairly new to me. In the past, I have created
applications by keeping a set of
10 matches
Mail list logo
