[GENERAL] c (lowercase) privilege

[Javier Carlos]

   Hi,

   Does anybody know what's the meaning of the c (lowercase) privilege in
PostgreSQL 8.2 Beta?

bd_test=# SELECT datacl FROM pg_catalog.pg_database WHERE datname='bd_test';
datacl
--
 {=CTc/user1,user1=CTc/user1}


   In 8.1 documentation is not listed:

  r -- SELECT ("read")
  w -- UPDATE ("write")
  a -- INSERT ("append")
  d -- DELETE
  R -- RULE
  x -- REFERENCES
  t -- TRIGGER
  X -- EXECUTE
  U -- USAGE
  C -- CREATE
  T -- TEMPORARY
arwdRxt -- ALL PRIVILEGES (for tables)
  * -- grant option for preceding privilege


   Thanks in advance,

   Javier


-
nediam.com.mx/en/


---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] pg_dump, pg_restore

[Javier Carlos]

   Basing on the way you did the pg_dump (without the -C option), I think you
should have created the database before you performed the pg_restore, 

   You can see some examples of database backup/restore in this page:

  http://nediam.com.mx/en/tips/backups_pgsql.php

Regards,
Javier



On Mon, 6 Feb 2006 10:54:27 +0530, surabhi.ahuja wrote
> i am trying to do :
> 
> pg_dump -f op.tar -F t database_name
> 
> then i do
> 
> dropdb database_name
> 
> and then i do pg_restore op.tar
> 
> and when i do psql database_name
> 
> it says database does not exist.
> 
> where am i going wrong?
> 
> thanks,
> 
> regards
> 
> Surabhi


--
nediam.com.mx


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

Re: [GENERAL] getting failed while creating user accounts

[Javier Carlos]

   Hi,

   In some *nix distributions the username 'postgres' is already in
/etc/passwd. If so, you don't need to create it again. Just assure that the
directory where the database cluster will reside belongs to the user
'postgres', and also when you'll go to create the DB cluster (with the command
'initdb') you have to do it as that non-root user (postgres).


   You can check this PostgreSQL installation manual, maybe it can help you:

http://nediam.com.mx/en/docs/postgresql_manual/index.php

   If you're trying to install PostgreSQL on Windows, just check that the
username doesn't exist in your computer neither in the DOMAIN/WORKGROUP where
you computer belongs.


  Regards,

  Javier


On Sun, 12 Mar 2006 09:12:38 + (GMT), venu gopal wrote
> Hi all,
>I m trying to install postgres8.1 on my system.I
> tried with account name postgres.I was getting an
> error of unable to create user account.user account
> already exists.
> If i try with any other user any of the following
> error is arising
> 
> 1.unable to create user account.user account already
> exists.
> 
> 2.Internal lookup failure.No mapping made between
> accountname and serviceIDs
> 
>   I tried it a number of time wiht number of account
> names and no of superuser names.I failed a number of
> times
>   How can i get installed with my postgres.If the user
> accounts exists then where should i remove them so
> that i can get that user name to be installed.
> 
>   Please give me the suggestions where i have to make
> changes to make my installation to be
> successful.Please reply me ASAP
> 
> Thanks and regards,
> venu.p
> 
>   
>   
>   
> ___ 
> Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with 
> voicemail http://uk.messenger.yahoo.com
> 
> ---(end of broadcast)---
> TIP 6: explain analyze is your friend


--
nediam.com.mx


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match