From: Marc Fromm [mailto:marc.fr...@wwu.edu]
Sent: Tuesday, March 29, 2011 1:52 PM
To: pgsql-admin@postgresql.org
Subject: odbc
I am running postgres on a red hat linux server.
postgresql-pyth
Hi,
We're planning to upgrade our PostgreSQL database from v8.2.3 to v9.0.3.
Before upgrading our Production server, we're trying out this complete
upgrade process in a separate database server that is just exactly the
replica of the production server.
I already took a dump of our database using
Στις Wednesday 30 March 2011 16:44:33 ο/η Gnanakumar έγραψε:
> Hi,
>
> We're planning to upgrade our PostgreSQL database from v8.2.3 to v9.0.3.
> Before upgrading our Production server, we're trying out this complete
> upgrade process in a separate database server that is just exactly the
> replic
Hi,
Our OS is CentOS5.2. We're upgrading our PostgreSQL database from v8.2.3 to
v9.0.3. Is there any default init script available in v9.0.3 for starting
up the PostgreSQL server so that it can be added to "/etc/init.d/"? I
couldn't find any service file in the installation source directory. I
Le 30/03/2011 16:13, Gnanakumar a écrit :
> [...]
> Our OS is CentOS5.2. We're upgrading our PostgreSQL database from v8.2.3 to
> v9.0.3. Is there any default init script available in v9.0.3 for starting
> up the PostgreSQL server so that it can be added to "/etc/init.d/"? I
> couldn't find any
On Wed, 2011-03-30 at 19:43 +0530, Gnanakumar wrote:
> Our OS is CentOS5.2. We're upgrading our PostgreSQL database from
> v8.2.3 to v9.0.3. Is there any default init script available in
> v9.0.3 for starting up the PostgreSQL server so that it can be added
> to "/etc/init.d/"? I couldn't find
On Tue, Mar 29, 2011 at 10:51 AM, Marc Fromm wrote:
> I am running postgres on a red hat linux server.
>
> postgresql-python-8.1.23-1.el5_6.1
>
> postgresql-test-8.1.23-1.el5_6.1
>
> postgresql-libs-8.1.23-1.el5_6.1
>
> postgresql-docs-8.1.23-1.el5_6.1
>
> postgresql-contrib-8.1.23-1.el5_6.1
>
>
I am working with a script to automate grant select to all tables in a database
to a user.
1 #!/bin/bash
2 for table in 'echo "SELECT relname FROM pg_stat_all_tables;" | psql cswe2 |
grep -v "pg_" | grep "^ "';
3 do
4 echo "GRANT SELECT ON TABLE $table to tom;"
5 echo "GRANT SELECT ON T
Marc Fromm wrote:
> I am working with a script to automate grant select to all tables
> in a database to a user.
You don't say what version you're using, but if it's available, you
might want to use the GRANT SELECT ON ALL TABLES IN SCHEMA syntax.
> The data base cswe2 does not contain the t
Marc,
Try pg_stat_user_tables - it will eliminate the tables in pg_catalog,
information_schema, and the toast tables.
Bob Lunney
--- On Wed, 3/30/11, Marc Fromm wrote:
From: Marc Fromm
Subject: [ADMIN] grant select script
To: "pgsql-admin@postgresql.org"
Date: Wednesday, March 30, 2011, 1:54
Hi,
when I used the postgres login 'replication' as the account for streaming
replication I get the following error message:
2011-03-28 18:06:47 CEST FATAL: could not connect to the primary server:
FATAL: no pg_hba.conf entry for replication connection from host
"172.16.56.122", user "replicatio
On Thu, Mar 31, 2011 at 12:07 AM, Uwe Bartels wrote:
> Hi,
>
> when I used the postgres login 'replication' as the account for streaming
> replication I get the following error message:
> 2011-03-28 18:06:47 CEST FATAL: could not connect to the primary server:
> FATAL: no pg_hba.conf entry for
On Thu, Mar 31, 2011 at 3:37 AM, Uwe Bartels wrote:
> when I used the postgres login 'replication' as the account for streaming
> replication I get the following error message:
> 2011-03-28 18:06:47 CEST FATAL: could not connect to the primary server:
> FATAL: no pg_hba.conf entry for replicatio
On 30 March 2011 22:43, raghu ram wrote:
>
>
> On Thu, Mar 31, 2011 at 12:07 AM, Uwe Bartels wrote:
>
>> Hi,
>>
>> when I used the postgres login 'replication' as the account for streaming
>> replication I get the following error message:
>> 2011-03-28 18:06:47 CEST FATAL: could not connect to t
On 31 March 2011 04:53, Fujii Masao wrote:
> On Thu, Mar 31, 2011 at 3:37 AM, Uwe Bartels
> wrote:
> > when I used the postgres login 'replication' as the account for streaming
> > replication I get the following error message:
> > 2011-03-28 18:06:47 CEST FATAL: could not connect to the primar
15 matches
Mail list logo
