> On Sat, Feb 28, 2009 at 7:54 PM, Daniel J. Summers
> wrote:
>> Bryan Keith wrote:
>>>
>>> I can run 8.3 and see the dbs (the default ones only; not mine) with
>>> psql.
>>>
>>
>> I ran into this on an upgrade - however, I didn't do what I'm about to
>> describe, and I lost all my data. Luckily,
On Sat, Feb 28, 2009 at 7:54 PM, Daniel J. Summers
wrote:
> Bryan Keith wrote:
>>
>> I can run 8.3 and see the dbs (the default ones only; not mine) with psql.
>>
>
> I ran into this on an upgrade - however, I didn't do what I'm about to
> describe, and I lost all my data. Luckily, it wasn't the o
Bryan Keith wrote:
I can run 8.3 and see the dbs (the default ones only; not mine) with psql.
I ran into this on an upgrade - however, I didn't do what I'm about to
describe, and I lost all my data. Luckily, it wasn't the only place
where it was, but there was some development stuff that I h
Hello,
I recently upgraded from Ubuntu 8.04 to 8.10. After the OS upgrade I
choose to upgrade software as well (all quite automated in ubuntu).
Previously I was running postgres 8.2, but now I have postgres 8.3 (and
hopefully 8.2 as well).
I can run 8.3 and see the dbs (the default ones only; n
Hi Andy,
Many thanks! That is the silver bullet I needed.
Hoorey!
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Andreas Wenk [mailto:a.w...@netzmeister-st-pauli.de]
Sent: Sat 2/28/2009 4:01 PM
To: Tena Sakai; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] grant qu
Tena Sakai schrieb:
Hi,
Nah, I don't think that theory holds water...
[tsa...@vixen ~]$ psql canon gjoslyn
Password for user gjoslyn:
Welcome to psql 8.3.6, the PostgreSQL interactive terminal.
canon=>
canon=> \z gallo.gallo.unlinkcol1
Access privileges for
Hi,
Nah, I don't think that theory holds water...
[tsa...@vixen ~]$ psql canon gjoslyn
Password for user gjoslyn:
Welcome to psql 8.3.6, the PostgreSQL interactive terminal.
canon=>
canon=> \z gallo.gallo.unlinkcol1
Access privileges for database "canon"
S
Hi,
Maybe I found the underlying problem...
too psql, I typed:
canon=# \dn gallo
and it told me:
List of schemas
Name | Owner
---+---
gallo | ysu
(1 row)
Maybe the supersuer postgres is unable to grant select
on that table... But it told me it did.
>> canon=# grant s
Hi Andy,
Thank you for your walk through.
Here's what I did, emulating your guidance and spirit:
-- about to create a new role
canon=# create role galloan;
CREATE ROLE
canon=#
canon=# \dg galloan
List of roles
Role name | Superuser | Create role | Create DB | Conn
You defo have all the required openssl headers and libs and configure succeeds?
It's a longshot, but I wonder if the prefix is somehow making configure read
the string wrong? I've never really needed to use prefix, but what happend if
you try
./configure --prefix='/DB' --with-openssl
or perhap
Hello,
I am trying to run PostgreSQL with SSL, so I compiled and linked with
options:
./configure --prefix=/DB --with-openssl
Configured and installed successfully.
In postgresql.conf I have option "ssl = on"
When starting Postgres I get error:
LOG: SSL is not supported by this build
FATAL: i
Tena Sakai schrieb:
Thank you, Scott, for your reply.
> Two problems. 1: you don't grant select on schemas, you grant it on
> tables. 2: case folding. If you're gonna use a name "schema_Z" then
> you have to quote it, because it's mixed case, not all lower.
> You need to grant it for ea
Thank you, Scott, for your reply.
> Two problems. 1: you don't grant select on schemas, you grant it on
> tables. 2: case folding. If you're gonna use a name "schema_Z" then
> you have to quote it, because it's mixed case, not all lower.
> You need to grant it for each table.
In actual comman
On Sat, Feb 28, 2009 at 12:56 PM, Tena Sakai wrote:
> Hi Everybody,
>
> I want to issue a command:
>
> grant select on schema_Z to user_a;
>
> so that the user_a can look at all tables in schema_Z.
> Sadly, what I get is:
> ERROR: relation "schema_Z" does not exist
Two problems. 1: you don'
Hi Everybody,
I want to issue a command:
grant select on schema_Z to user_a;
so that the user_a can look at all tables in schema_Z.
Sadly, what I get is:
ERROR: relation "schema_Z" does not exist
I tried:
grant select on schema_Z.* to user_a;
and response was:
ERROR: syntax error a
15 matches
Mail list logo
