Ha tá, seu arquivo de configuração está no /etc/postgresql/8.4/main Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação Pós-graduando em Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR DBA Postgres ------------------------------- “A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"
2012/6/28 Bruno Dias Leite <[email protected]> > whoami: postgres > > ********************************************************************************************* > stat /var/lib/postgresql/8.4/main/ > File: `/var/lib/postgresql/8.4/main/' > Size: 4096 Blocks: 8 IO Block: 4096 diretório > Device: 801h/2049d Inode: 202439 Links: 11 > Access: (0755/drwxr-xr-x) Uid: ( 115/postgres) Gid: ( 123/postgres) > Access: 2012-06-28 15:22:37.576276979 -0300 > Modify: 2012-06-28 15:22:37.470186098 -0300 > Change: 2012-06-28 15:24:07.564790286 -0300 > > ********************************************************************************************** > ls /var/lib/postgresql/8.4/main/ > base pg_clog pg_stat_tmp pg_tblspc PG_VERSION postmaster.opts > global pg_multixact pg_subtrans pg_twophase pg_xlog > > > > ******************************************************************************************* > > Sim sim, restaurei todos os arquivos que existia no antigo diretório do > postgres > > > > > Em 28 de junho de 2012 15:48, Bruno Silva <[email protected]>escreveu: > > Retorne a saída dos comandos a seguir: >> whoami >> stat /var/lib/postgresql/8.4/main/ >> ls /var/lib/postgresql/8.4/main/ >> >> Você não disse que restaurou essa pasta por completo? >> >> Bruno E. A. Silva. >> Analista de Sistemas. >> >> >> 2012/6/28 Bruno Dias Leite <[email protected]> >> >>> Acredito que o arquivo não exista, pq estou usando o postgres para >>> executar o pg_ctl. E os diretório do /main tem a permissão o postgres >>> >>> >>> Em 28 de junho de 2012 15:35, Bruno Silva <[email protected]>escreveu: >>> >>> Então, ou ele não tem permissão na pasta ou o arquivo não existe. >>>> Verifique as permissões das pastas e dos arquivos. Qual o usuário que >>>> você está usando quando executa o pg_ctl? >>>> >>>> Bruno E. A. Silva. >>>> Analista de Sistemas. >>>> >>>> >>>> 2012/6/28 Bruno Dias Leite <[email protected]> >>>> >>>>> Como não tinha permissão criar saida.log >>>>> >>>>> >>>>> executei normal e retornou: >>>>> >>>>> laptop:/usr/lib/postgresql/8.4/bin$ ./pg_ctl start -D >>>>> /var/lib/postgresql/8.4/main/ >>>>> servidor está iniciando >>>>> postgres@coss-laptop:/usr/lib/postgresql/8.4/bin$ postgres não pode >>>>> acessar o arquivo de configuração do servidor >>>>> "/var/lib/postgresql/8.4/main/postgresql.conf": Arquivo ou diretório não >>>>> encontrado >>>>> >>>>> >>>>> Em 28 de junho de 2012 15:07, Bruno Silva <[email protected]>escreveu: >>>>> >>>>> Substitua somente o 8.4/main >>>>>> Tente iniciar usando: >>>>>> sudo su - postgres >>>>>> pg_ctl -D <caminho do main> -l saida.log >>>>>> >>>>>> >>>>>> E veja o que retorna no log. >>>>>> >>>>>> Bruno E. A. Silva. >>>>>> Analista de Sistemas. >>>>>> Bacharel em Sistemas de Informação >>>>>> Pós-graduando em Gerência de Projetos >>>>>> Certified Scrum Master >>>>>> LPIC-1 >>>>>> SCJP, SE 6 >>>>>> Novell CLA / DCTS ECR >>>>>> DBA Postgres >>>>>> ------------------------------- >>>>>> “A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” >>>>>> - Sábio Desconhecido >>>>>> "Alguns prestam serviço/consultoria de Qualidade, os outros vendem >>>>>> licença!" >>>>>> >>>>>> >>>>>> >>>>>> 2012/6/28 Bruno Dias Leite <[email protected]> >>>>>> >>>>>>> HEheh... de certo o problema do PID foi resolvido porém continua não >>>>>>> querendo inciar o postgresql >>>>>>> >>>>>>> -laptop:/var/lib/postgresql/8.4/main$ sudo service postgresql-8.4 >>>>>>> start * Starting PostgreSQL 8.4 database server >>>>>>> * Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl >>>>>>> /usr/lib/postgresql/8.4/bin/pg_ctl start -D >>>>>>> /var/lib/postgresql/8.4/main -l >>>>>>> /var/log/postgresql/postgresql-8.4-main.log -s -o -c >>>>>>> config_file="/etc/postgresql/8.4/main/postgresql.conf" : >>>>>>> >>>>>>> [fail] >>>>>>> -laptop:/var/lib/postgresql/8.4/main$ >>>>>>> >>>>>>> >>>>>>> Inclusive os arquivos originais(da instalação do binário) não esta >>>>>>> funcionando quando eu o substituo de volta. >>>>>>> >>>>>>> Obs. Estou fazendo a substituição de todo o diretório >>>>>>> /var/lib/postgres >>>>>>> >>>>>>> Em 28 de junho de 2012 13:38, Bruno Silva >>>>>>> <[email protected]>escreveu: >>>>>>> >>>>>>> Você substituiu os arquivos com o SGBD inicializado? >>>>>>>> Se sim, pare antes de fazer isso. >>>>>>>> Se não, remova o arquivo pid >>>>>>>> (/var/lib/postgresql/8.4/main/postmaster.pid) >>>>>>>> >>>>>>>> Bruno E. A. Silva. >>>>>>>> Analista de Sistemas. >>>>>>>> Bacharel em Sistemas de Informação >>>>>>>> Pós-graduando em Gerência de Projetos >>>>>>>> Certified Scrum Master >>>>>>>> LPIC-1 >>>>>>>> SCJP, SE 6 >>>>>>>> Novell CLA / DCTS ECR >>>>>>>> DBA Postgres >>>>>>>> ------------------------------- >>>>>>>> “A caixa dizia: Requer MS Windows ou superior. Então instalei >>>>>>>> Linux.” - Sábio Desconhecido >>>>>>>> "Alguns prestam serviço/consultoria de Qualidade, os outros vendem >>>>>>>> licença!" >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> 2012/6/28 Bruno Dias Leite <[email protected]> >>>>>>>> >>>>>>>>> Estou usando Ubuntu 10.04, e já instalei novamente o >>>>>>>>> postgresql-8.4 pelo apt-get >>>>>>>>> A permissão pasta original estava postgres:postgres, porém quando >>>>>>>>> eu substituo os >>>>>>>>> arquivos. Ao iniciar o serviço do postgres ele falha. >>>>>>>>> >>>>>>>>> sudo service postgresql-8.4 restart >>>>>>>>> * Restarting PostgreSQL 8.4 database >>>>>>>>> server * Use of uninitialized >>>>>>>>> value >>>>>>>>> $pid in scalar chomp at /usr/bin/pg_ctlcluster line 50. >>>>>>>>> Use of uninitialized value $pid in pattern match (m//) at >>>>>>>>> /usr/bin/pg_ctlcluster line 51. >>>>>>>>> Removed stale pid file. >>>>>>>>> Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl >>>>>>>>> /usr/lib/postgresql/8.4/bin/pg_ctl start -D >>>>>>>>> /var/lib/postgresql/8.4/main -l >>>>>>>>> /var/log/postgresql/postgresql-8.4-main.log -s -o -c >>>>>>>>> config_file="/etc/postgresql/8.4/main/postgresql.conf" : >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> Não sei como resolver isso, já tentei substituir arquivos, mudar >>>>>>>>> permissão mas nada que eu faz inicializa o postgresql >>>>>>>>> como os arquivos antigos. >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> Em 28 de junho de 2012 11:31, Bruno Silva >>>>>>>>> <[email protected]>escreveu: >>>>>>>>> >>>>>>>>> Você está usando que distribuição? >>>>>>>>>> Já instalou os binários do Postgres? >>>>>>>>>> Tendo instalado os binários verifique a permissão da pasta ' >>>>>>>>>> /var/lib/postgres/main/8.4' >>>>>>>>>> E inicialize o Postgres com o comando pg_ctl: >>>>>>>>>> pg_ctl -D /var/lib/postgres/main/8.4 start >>>>>>>>>> >>>>>>>>>> Bruno E. A. Silva. >>>>>>>>>> Analista de Sistemas. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> 2012/6/28 Bruno Dias Leite <[email protected]> >>>>>>>>>> >>>>>>>>>>> Pessoal, estava com o postgresql instalado em uma partição do >>>>>>>>>>> linux, mas por algum motivo não >>>>>>>>>>> consigo mais entrar nele. Recuperei a pasta >>>>>>>>>>> /var/lib/postgres/main/8.4... inteira e gostaria de tentar restaurar >>>>>>>>>>> meus antigos banco de dados. Se alguém souber um tutorial >>>>>>>>>>> agradeço muitíssimo :D >>>>>>>>>>> >>>>>>>>>>> Obrigado a todos >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> att. >>>>>>>>>>> * >>>>>>>>>>> >>>>>>>>>>> Bruno Dias Leite* >>>>>>>>>>> * >>>>>>>>>>> * >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> 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 >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> att. >>>>>>>>> * >>>>>>>>> >>>>>>>>> Bruno Dias Leite* >>>>>>>>> *55 16 88037782* >>>>>>>>> Analista de Sistema >>>>>>>>> *Ciência da Computação UFSCar * >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> 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 >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> att. >>>>>>> * >>>>>>> >>>>>>> Bruno Dias Leite* >>>>>>> *55 16 88037782* >>>>>>> Analista de Sistema >>>>>>> *Ciência da Computação UFSCar * >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> 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 >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> att. >>>>> * >>>>> >>>>> Bruno Dias Leite* >>>>> *55 16 88037782* >>>>> Analista de Sistema >>>>> *Ciência da Computação UFSCar * >>>>> >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> 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 >>>> >>>> >>> >>> >>> -- >>> att. >>> * >>> >>> Bruno Dias Leite* >>> *55 16 88037782* >>> Analista de Sistema >>> *Ciência da Computação UFSCar * >>> >>> >>> >>> >>> _______________________________________________ >>> 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 >> >> > > > -- > att. > * > > Bruno Dias Leite* > *55 16 88037782* > Analista de Sistema > *Ciência da Computação UFSCar * > > > > > _______________________________________________ > 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
