Olá, Acho que o problema é que vc quer iniciar o banco como usuário "administrador" do S.O. (no caso do unix root, no windows acho que eh administrador). quando vc der o initdb tem que ser como o usuario administrador do banco, o padrão é o postgres mas acho que no seu caso é manual (é isso mesmo? vc criou o usuário manual ou vc criou o usuário postgres de modo manual?)
[]'s -- Luigi Castro Cardeles 2008/7/18 Marcos <[EMAIL PROTECTED]>: > olá pessoal > estava tentando instalar o postgres no windows, mas dava erro por causa do > usuário que a instalação cria. > então cadastrei o usuário manual, conforme alguns exemplos, e instalei o > postgres, deu certo > mas agora não consigo iniciar o banco, criei um script para isso > segue abaixo os comando em execução > > > > *C:\WINDOWS\system32>cd\* > ** > *C:\> > C:\>postgres.bat* > ** > *C:\>cd\* > ** > *C:\>cd postgres* > ** > *C:\postgres>cd bin* > ** > *C:\postgres\bin>initdb -D "c:\postgres\data" > The files belonging to this database system will be owned by user > "administrator". > This user must also own the server process.* > ** > *The database cluster will be initialized with locale > Portuguese_Brazil.1252.* > ** > *fixing permissions on existing directory c:/postgres/data ... ok > creating directory c:/postgres/data/global .. ok > creating directory c:/postgres/data/pg_xlog ... ok > creating directory c:/postgres/data/pg_xlog/archive_status ... ok > creating directory c:/postgres/data/pg_clog ... ok > creating directory c:/postgres/data/pg_subtrans ... ok > creating directory c:/postgres/data/pg_twophase ... ok > creating directory c:/postgres/data/pg_multixact/members ... ok > creating directory c:/postgres/data/pg_multixact/offsets ... ok > creating directory c:/postgres/data/base ... ok > creating directory c:/postgres/data/base/1 ... ok > creating directory c:/postgres/data/pg_tblspc ... ok > selecting default max_connections ... 10 > selecting default shared_buffers ... 50 > creating configuration files ... ok > creating template1 database in c:/postgres/data/base/1 ... Execution of > PostgreSQL by a user with ad > ministrative permissions is not > permitted. > The server must be started under an unprivileged user ID to prevent > possible system security compromises. See the documentation for > more information on how to properly start the server. > child process was terminated by signal 1 > initdb: removing contents of data directory "c:/postgres/data"* > ** > *C:\postgres\bin>pg_ctl start -D "c:\postgres\data" > postmaster starting > Execution of PostgreSQL by a user with administrative permissions is not > permitted. > The server must be started under an unprivileged user ID to prevent > possible system security compromises. See the documentation for > more information on how to properly start the server. > C:\postgres\bin> > C:\postgres\bin>* > > > > Atenciosamente, > Marcos Fabrício Corso > Analista de Sistemas Júnior > JM Informática > Fone : (41) 3076-0896 > Fax : (41) 3352-2688 > [EMAIL PROTECTED] > www.informaticajm.com.br > > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > >
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
