Hi Benjamin, at first i will send you the postgresql.log tomorrow because it is the computer at work. But here are some informations.
I wrote in the /etc/services the name 'postgresql 5432/tcp' Then i wrote in the /etc/hosts.allow 'postgresql: ALL Toni 2006/10/25, Benjamin Kircher <[EMAIL PROTECTED]>: > Hi, > I agree completely, this wiki is not a step-by-step description on how > to set up a postgresql to be accessible from remote, so some questions > are not answered. > But perhaps we can help. Can you tail /var/log/postgresql.log and post > it here? And as already suggested, did you take a look at the > /etc/hosts.allow? > > And excuse my bad English. > > -- > Benjamin > > > Anton Achatz wrote: > > Hi, > > I´ve installed the postgresql package. Now I did the entries in the > > conf-files that i was introduced from the wiki. > > > > postgresql.conf (in the data/postgresql path) > > listen_addresses = '*' > > > > pg_hba.conf > > host all all ip/32 trust (my ip is 194.95.98.74 netmask 255.255.255.0) > > > > Then i start the database with > > /etc/rc.d/postgresql start > > > > Now initdb testdb restart postgres again with /etc/rc.d/postgresql > > restart. Now I get the message that i can start the testdb with > > postmaster -D testdb, but isn't it possible to start in rc.conf with > > postgresql. Then i downloaded the pgadmin3 software. trying to connect > > failed. Now i stopped the database and connected it with postmaster -D > > testdb in a normal user profile and tried pgadmin again and it worked. > > Why? > > > > > > All this i did with localhost. Trying to connect from another pc the > > connection failed anytime. > > > > My source is to have a small pc with postgres running and connect it > > with a remote computer. > > > > can somebody help me. > > Toni > > > > _______________________________________________ > > arch mailing list > > [email protected] > > http://www.archlinux.org/mailman/listinfo/arch > > > > > > _______________________________________________ > arch mailing list > [email protected] > http://www.archlinux.org/mailman/listinfo/arch > _______________________________________________ arch mailing list [email protected] http://www.archlinux.org/mailman/listinfo/arch
