Thread: Problem with pg_dump
Hi! I´m start to work with postgresql, and I have some problema when I try to run pg_dump. If I execute: pg_dump mibd -U postgres > midb.out Don´t receive any error message, but midb.out is empty.... (0 kb) I can create databases, searchs, imports, etc... My postgresql´s version is 8.1.2 and the SO is RHL 4 and the packages installed (by rpm) were: postgresql, postgresqlcontrib, postgresqlserver, postgresqllibs I hope, that someone can help me... Thanks a lot! -- Lo invitamos a disfrutar de nuestro servicio de Call Center, a través del Tlf. 0800-OPEN-000 Conoce Usted nuestro programa de Recompensas Open Pass? http://www.openworldconsult.com.ve/OpenPass/openpass.htm Luzmar Caicedo Useche Ingeniero de Soporte Open World Consultores, C.A. -Venezuela- luzmar.caicedo@open-world.com.ve http://www.openworldconsult.com.ve "El que no vive para servir, no sirve para vivir" Puerto Ordaz 58 286 9515973 Caracas 58 212 9594777 Maracaibo 58 261 7983369 Mérida 0800 OPEN-000 Móvil 58 416 4153234
Luzmar Caicedo Useche <luzmar.caicedo@open-world.com.ve> writes: > If I execute: > pg_dump mibd -U postgres > midb.out > Don�t receive any error message, but midb.out is empty.... (0 kb) Given that it's RHEL4, maybe you have a selinux permissions problem? Does /usr/sbin/getenforce say that selinux is in enforcing mode, and if so, does pg_dump work better after doing "/usr/sbin/setenforce 0" as root? If so, you probably need to update your selinux policy module. regards, tom lane
Thanks Tom, It´s work for me! Thanks a lot again! Tom Lane wrote: >Luzmar Caicedo Useche <luzmar.caicedo@open-world.com.ve> writes: > > >>If I execute: >>pg_dump mibd -U postgres > midb.out >>Don´t receive any error message, but midb.out is empty.... (0 kb) >> >> > >Given that it's RHEL4, maybe you have a selinux permissions problem? >Does /usr/sbin/getenforce say that selinux is in enforcing mode, >and if so, does pg_dump work better after doing "/usr/sbin/setenforce 0" >as root? > >If so, you probably need to update your selinux policy module. > > regards, tom lane > >---------------------------(end of broadcast)--------------------------- >TIP 5: don't forget to increase your free space map settings > > -- Lo invitamos a disfrutar de nuestro servicio de Call Center, a través del Tlf. 0800-OPEN-000 Conoce Usted nuestro programa de Recompensas Open Pass? http://www.openworldconsult.com.ve/OpenPass/openpass.htm Luzmar Caicedo Useche Ingeniero de Soporte Open World Consultores, C.A. -Venezuela- luzmar.caicedo@open-world.com.ve http://www.openworldconsult.com.ve "El que no vive para servir, no sirve para vivir" Puerto Ordaz 58 286 9515973 Caracas 58 212 9594777 Maracaibo 58 261 7983369 Mérida 0800 OPEN-000 Móvil 58 416 4153234