Re: [ADMIN] encoding problem

2003-03-25 Thread Fouad Fezzi
-Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] la part de Alexey A. Britchko Envoye : mardi 25 mars 2003 07:08 A : [EMAIL PROTECTED] Objet : [ADMIN] encoding problem Hi there How did upgrade from pgsql 6.x to pgsql 7.x: 1. Dumped database 2. ./configure

Re: [ADMIN] GRANT access on table fields

2003-02-28 Thread Fouad Fezzi
Hi , I don't know if you can grant field but i think it's more interesting to create view and grant users this view. later please see documentation before request. Fouad -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] la part de Nathalie Boulos Envoyé : vendredi 28

[ADMIN] command to rename a database

2002-11-28 Thread Fouad Fezzi
Hi, I don't see command to rename database. Yes, i can drop/create/restore database but is there any problems to develop such command ? Fouad Fezzi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [ADMIN] pg_hba.conf file review

2002-11-22 Thread Fouad Fezzi
Hi dan IF possible i suggest to put a restriction from where your users come with netwotk and mask. I think that your solution is to complicate and suggest that all database is owned by postgres with strong password and give your user full grant for a single database. so you haven't to manage a

Re: [ADMIN] User's managing

2002-07-17 Thread Fouad Fezzi
Hi Cyrill According to postgresql doc there is no future for that .So you have to do that for all tables in you database with grant. In 7.2 any user can create table in your database so you have nothing to do this hole future do it for you. Perhaps in 7.3 this future will be included. Fouad

[ADMIN] how to cron pg_dump and vaccum

2002-03-07 Thread Fouad Fezzi
Hi I want to program pg_dump in crontab but with authentification of user pg_dump prompt a user name and password. how can i backup my database automatic (one backup for a day). pg_version :7.0 Thanks -- ___ Fouad Fezzi Ingenieur Réseau IUP Institut Universitaire

[ADMIN] pg_log problem

2002-03-01 Thread Fouad Fezzi
Hi my pg_log seem to have crash and i can see my database . is there any help for to regernrate pg_log thanks ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster