From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <week@altlinux.ru>
To: mandrake-russian@altlinux.ru
Subject: Re: [mdk-re] postgress
References: <11867431942.20020219123916@mail.ru>
	<0GRS007G30CC1B@mxout2.netvision.net.il>
From: Grigory Milev <week@altlinux.ru>
In-Reply-To: <0GRS007G30CC1B@mxout2.netvision.net.il>
Message-ID: <87y9hpln70.fsf@pc349.belcaf.minsk.by>
User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.4 (Academic Rigor)
MIME-Version: 1.0
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 8bit
Sender: mandrake-russian-admin@altlinux.ru
Errors-To: mandrake-russian-admin@altlinux.ru
X-BeenThere: mandrake-russian@altlinux.ru
X-Mailman-Version: 2.0
Precedence: bulk
Reply-To: mandrake-russian@altlinux.ru
List-Help: <mailto:mandrake-russian-request@altlinux.ru?subject=help>
List-Post: <mailto:mandrake-russian@altlinux.ru>
List-Subscribe: <http://altlinux.ru/mailman/listinfo/mandrake-russian>,
	<mailto:mandrake-russian-request@altlinux.ru?subject=subscribe>
List-Id: Linux-Mandrake RE / ALT Linux discussion list <mandrake-russian.altlinux.ru>
List-Unsubscribe: <http://altlinux.ru/mailman/listinfo/mandrake-russian>,
	<mailto:mandrake-russian-request@altlinux.ru?subject=unsubscribe>
List-Archive: <http://altlinux.ru/pipermail/mandrake-russian/>
Date: Tue Feb 19 14:47:26 2002
X-Original-Date: 19 Feb 2002 13:34:43 +0200
Archived-At: <http://lore.altlinux.org/community/87y9hpln70.fsf@pc349.belcaf.minsk.by/>
List-Archive: <http://lore.altlinux.org/community/>
List-Post: <mailto:mandrake-russian@linuxteam.iplabs.ru>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

>>>>> "Igor" == Igor Tertishny <yuda66@yandex.ru> writes:

    Igor> 19 Февраль 2002 11:39, Вы написали:
    >> Hello mandrake-russian,
    >> 
    >> господа подскажите ,пожалуйста , как в постгрес добавить нового
    >> пользователя

    Igor> Почитайте инфу по адресу:
    Igor> http://linux.yaroslavl.ru/Docum/Serv/psql/index.html

psql template1 -U postgres\n
CREATE USER username WITH SYSID uid PASSWORD 'password' [CREATEDB | NOCREATEDB] [CREATEUSER | NOCREATEUSER];\n
\q\n


Если просто добавить пользователя, можно сократить:
CREATE USER username WITH PASSWORD 'asdfgsdfg';


+-------------------------------------------------------+
Grigory Milev	mailto://week@altlinux.ru
ALT Linux Team	http://www.altlinux.ru
PC Club owner	mailto://pcclub@tut.by
+-------------------------------------------------------+
Life too beautiful and interest... Don't worry, be happy.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.5 and Gnu Privacy Guard <http://www.gnupg.org/>

iD8DBQE8cjhTS14SMK5ZwWARAvpFAJ98wQlb5WluoTawqZEjcnI86ZWeMgCfSclu
YTmHy61lUNbKfj4P6C4YsEo=
=nVtm
-----END PGP SIGNATURE-----