is that I have a number of postgres cluster we want to consolidate into a
single cluster. Every cluster has a database with different schemas names
each therefore inprinciple could create a single database where they could
live all schemas and should have no problem, we generate a dump and SQL file
Am 29.11.2011 22:06, schrieb Colin E Busse:
> Is there a way to set this up so that I can simply call:
>
> service postgresql start
You could patch your init-script located inside /etc/init.d or something
to do that. This might can get issues on regular system updates.
Cheers,
Frank
signature
On 11/30/2011 05:05 PM, M. D. wrote:
On 11/29/2011 11:52 PM, senthilnathan wrote:
Is there any simple way to define read only roles. Basically that
user should
be able to login and be able to do *select* statements alone. It
should be
applied for all tables in all schemas in a database.
--
V
Rudolf van der Leeden wrote:
> Hi,
>
> upgrading Postgres 9.0.5 to 9.1.1 is done using:
>
> - pg_upgrade
> - CREATE EXTENSION citext FROM unpackaged (using the latest patch)
>
> This works fine even for indexes on citext columns.
> The problem comes with an index on LOWER(citext), e.g. the ind
Hi,
I want get cold backup of database cluster, but in database cluster
there are four non-built-in tablespaces. So, when get the cold backup of
database cluster and restore on another machine and I check tablespaces for
that there is no any non-built-in tablespace is available.
So,Please
