Il giorno dom, 22/02/2015 alle 14.53 -0500, Tom Lane ha scritto:
[...]
That's because the above claim is nonsense. pg_largeobject is not shared
across databases of a cluster.
You could well have collisions against large objects in the same database,
though, if you're adding more large
Howdy,
I am looking for advice on migrating to postgres from another database
system.
Without going into too much detail, my company offers a software
solution which we self host ourselves in our data center. We have gotten
a green light from management to start using postgres as a free and
Giuseppe Sacco wrote:
Another important fact is about large objects, if you happen to use
them: their OID is not just unique to the database, but to the whole
cluster. This means that when you move a database in a cluster from a
production system to a database on a test cluster, you
Il giorno sab, 21/02/2015 alle 16.01 -0600, Samuel Smith ha scritto:
Howdy,
I am looking for advice on migrating to postgres from another database
system.
[...]
People already wrote you some comments, here are two more.
DB2 instances run as different OS users, so if you need the same
Daniel Verite dan...@manitou-mail.org writes:
Giuseppe Sacco wrote:
Another important fact is about large objects, if you happen to use
them: their OID is not just unique to the database, but to the whole
cluster. This means that when you move a database in a cluster from a
production
On Sat, Feb 21, 2015 at 3:01 PM, Samuel Smith pg...@net153.net wrote:
Howdy,
I am looking for advice on migrating to postgres from another database
system.
Without going into too much detail, my company offers a software solution
which we self host ourselves in our data center. We have
Samuel Smith schrieb am 23.02.2015 um 05:21:
I am stuck with redhat as the OS so I'll only have initdb. But this is a good
point.
I assume there is nothing wrong with having multiple postgres instances
(clusters) all running under a
single postgres user on different ports on the same
On Feb 23, 2015 5:29 AM, Samuel Smith pg...@net153.net wrote:
On 02/22/2015 01:53 PM, Scott Marlowe wrote:
I'd run a debian based distro (Ubuntu or Debian work well) and use the
pg_* commands to create the clusters the same way. Gives you the
maximum separation for clients.
On 23/02/15 15:53, Samuel Smith wrote:
On 02/21/2015 05:25 PM, David Steele wrote:
On 2/21/15 6:08 PM, Adrian Klaver wrote:
Currently the built in replication solutions work at the cluster level,
not at the database level. There are third party tools, Slony and
Bucardo come to mind, that can
On 02/22/2015 01:53 PM, Scott Marlowe wrote:
I'd run a debian based distro (Ubuntu or Debian work well) and use the
pg_* commands to create the clusters the same way. Gives you the
maximum separation for clients.
pg_createcluster
Usage: /usr/bin/pg_createcluster [options] version cluster
On 23/02/15 17:21, Samuel Smith wrote:
On 02/22/2015 01:53 PM, Scott Marlowe wrote:
I'd run a debian based distro (Ubuntu or Debian work well) and use the
pg_* commands to create the clusters the same way. Gives you the
maximum separation for clients.
pg_createcluster
Usage:
On 02/21/2015 05:25 PM, David Steele wrote:
On 2/21/15 6:08 PM, Adrian Klaver wrote:
Currently the built in replication solutions work at the cluster level,
not at the database level. There are third party tools, Slony and
Bucardo come to mind, that can work at a more focused level.
Again,
Howdy,
I am looking for advice on migrating to postgres from another database
system.
Without going into too much detail, my company offers a software
solution which we self host ourselves in our data center. We have gotten
a green light from management to start using postgres as a free and
On 02/21/2015 02:01 PM, Samuel Smith wrote:
Howdy,
I am looking for advice on migrating to postgres from another database
system.
Without going into too much detail, my company offers a software
solution which we self host ourselves in our data center. We have gotten
a green light from
On 2/21/15 6:08 PM, Adrian Klaver wrote:
On 02/21/2015 02:01 PM, Samuel Smith wrote:
Howdy,
I am looking for advice on migrating to postgres from another database
system.
Without going into too much detail, my company offers a software
solution which we self host ourselves in our data
15 matches
Mail list logo
