Hi All,
I have a couple of questions hopefully someone can help me with.
1) Does every relation exist in pg_class? Can we assume that if there is a file
with OID which is not present in pg_class, this file can be deleted? (we have a
few such files, some of them take more than 2G of space in to
I need to check, from a bash script, if certain database exists in a
postgres cluster. When I issue:
psql -U someuser somedatabase
psql returns error code 2 regardless of 'no user' or 'no database'
condition. How could I distinguish from the two?
Mario
--
Sent via pgsql-admin mailing lis
Hallo to all! I use Postgres 8.1 and i've got problem in its usermanagement.
Here is me roles list:
nausd=# \du
List of roles
Role name | Superuser | Create role | Create DB | Connections | Member of
-+---+-+---+-+--
dss0 | yes | yes
Mario Splivalo написа:
I need to check, from a bash script, if certain database exists in a
postgres cluster. When I issue:
psql -U someuser somedatabase
psql returns error code 2 regardless of 'no user' or 'no database'
condition. How could I distinguish from the two?
A workaround: add "--
Did you check the option "Inherits rights from parent roles" (parameter
INHERIT in SQL) for user testus ?
Dmitry Shubin rašė:
Hallo to all! I use Postgres 8.1 and i've got problem in its
usermanagement.
Here is me roles list:
nausd=# \du
List of roles
Role name | Superuser | Create role | Cr
Hello Valter,
I am doing something similar with the Windows installer for the PostBooks
project. Basically, what I do is this:
1. Use the Postgres windows installer to install 8.2.7
2. Import all the application's databases.
3. Using the NSIS Installer Generation app:
1. Include all files u
Thanks a lot, that was the problem!
On 4/15/08, Julius Tuskenis <[EMAIL PROTECTED]> wrote:
>
> Did you check the option "Inherits rights from parent roles" (parameter
> INHERIT in SQL) for user testus ?
>
>
> Dmitry Shubin rašė:
>
> > Hallo to all! I use Postgres 8.1 and i've got problem in its
>
[EMAIL PROTECTED] writes:
> 1) Does every relation exist in pg_class? Can we assume that if there is a
> file with OID which is not present in pg_class, this file can be deleted? (we
> have a few such files, some of them take more than 2G of space in total)
You do know it's relfilenode that coun
Hi Tom,
Thanks for your reply.
I did mean the data/OIDs from the relfilenode column in pg_class.
Even when logged in as root, a 'ls -l' command returns:
mm2:/var/lib/pgsql82/data/base/16673 # ls -lash | more
/bin/ls: 19357877: Permission denied
/bin/ls: 19569529: Permission denied
/bin/ls: 1956
[EMAIL PROTECTED] writes:
> Even when logged in as root, a 'ls -l' command returns:
> mm2:/var/lib/pgsql82/data/base/16673 # ls -lash | more
> /bin/ls: 19357877: Permission denied
> /bin/ls: 19569529: Permission denied
You get that as root? I think you've got filesystem problems that are
beyond
Darren Reed <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> BTW, could you send me the contents of file 24579 in that database
>> (dump it with pg_filedump, same as before)? According to your dump
>> that's the reindexed version of pg_class_oid_index, and I'm curious
>> to see whether it contains
Hi,
Iam getting "User 'postgres' could not be created.The user account already
exists.!" error while installing Postgresql version 8.2 in windows xp.There is
no user account named postgres created.
Please help me in this regard. Thanks & RegardsSaji Verghese91-9941140433
___
On Tue, Apr 15, 2008 at 9:51 AM, saji verghese
<[EMAIL PROTECTED]> wrote:
> Iam getting "User 'postgres' could not be created.The user account already
> exists.!" error while installing Postgresql version 8.2 in windows xp.There
> is no user account named postgres created.
This usually means that
Richard:
Actually, some systems have a user by the name of postgres
already on the system. Can change the setting for the user postgres by
adding a password,home directory and shell for the user postgres. Or Saji
can delete the user and then recreate it. I'm assuming that Saji has r
On Montag, 14. April 2008 Michael Monnerie wrote:
> > What do you mean "shared from 2 servers"? Are these two servers
> > using a shared network mount with the database files? Or do you
> > mean that these two servers connect as clients to a single Postgres
> > server?
>
> Two servers have SA run
On Montag, 14. April 2008 Michael Monnerie wrote:
> problem with duplicate primary index entries...
I just got a warning in my Log:
Apr 16 01:52:19 db1.zmi.at postgres[21103]: [3-1] DB=bayes_pg_v1_dupidx
U=postgres H=[local] 48053eaf.526f VACUUM:WARNUNG:
Index »bayes_token_pkey« enthält 253965
16 matches
Mail list logo
