fedora-docs-l10n/quick-docs/master/pages/postgresql — Portuguese (Brazil) @ Fedora Weblate: systemd

Zen

	English	Portuguese (Brazil)	Actions
	Firewall	Firewall
	PostgreSQL operates on port 5432 (or whatever else you set in your `postgresql.conf`). In firewalld you can open it like this:
	# make it last after reboot firewall-cmd --permanent --add-port=5432/tcp # change runtime configuration firewall-cmd --add-port=5432/tcp
	In the case of iptables:
	iptables -A INPUT -p tcp --dport 5432 -m state --state NEW,ESTABLISHED -j ACCEPT
	Bear in mind that you probably don't want to open your database server to the whole world.
	SELinux	SELinux
	If you have SELinux enforced, you may run into trouble when trying to do some non-standard configuration. For example, if you would like to change a location of your database, you have to add new context mapping for the new location:
	semanage fcontext -a -t postgresql_db_t "/my/new/location(/.*)?"
	If the default port doesn't work for you, you may need to map postgre's port type to your desired port:
	semanage port -a -t postgresql_port_t -p tcp 5433
	If you install a webapp that wants to communicate with PostgreSQL via TCP/IP, you will have to tell SELinux to allow this on the webserver host:
	setsebool -P httpd_can_network_connect_db on
	Configuration	Configuração
	As mentioned above, the postgresql server is using two main configuration files
	systemd	systemd
	Some configuration parameters are passed to daemon via command line options. This behaviour may override settings in `postgresql.conf`. For example, if you want to change the server's port number to 5433, create a file named `/etc/systemd/system/postgresql.service` containing:
	.include /lib/systemd/system/postgresql.service [Service] Environment=PGPORT=5433
	Note: changing PGPORT or PGDATA will typically require adjusting SELinux configuration as well; see section selinux.
	Please follow the systemd documentation http://fedoraproject.org/wiki/systemd#How_do_I_customize_a_unit_file.2F_add_a_custom_unit_file.3F[2] for more details.
	postgresql.conf
	If you want postgres to accept network connections, you should change
	listen_addresses = 'localhost'
	to	para
	listen_addresses = '*'
	pg_hba.conf
	Once your database is set up, you need to configure access to your database server. This may be done by editing file `/var/lib/pgsql/data/pg_hba.conf`. There are rules like this in the file:
	# TYPE DATABASE USER ADDRESS METHOD host all all 127.0.0.1/32 md5 host all all ::1/128 md5 local all postgres peer
	First field stands for connection type. It can have these values:
	local — Unix-domain socket
	host — plain or SSL-encrypted TCP/IP socket

Loading…

anonymous Suggestion added fedora-docs-l10n/quick-docs master/pages/postgresql Portuguese (Brazil)	English systemd Portuguese (Brazil) 0 characters edited Current translation systemd a year ago
farribeiro Marked for edit fedora-docs-l10n/quick-docs master/pages/postgresql Portuguese (Brazil)	English systemd Portuguese (Brazil) 7 characters edited Current translation Needs editing systemd a year ago
farribeiro Suggestion removed fedora-docs-l10n/quick-docs master/pages/postgresql Portuguese (Brazil)	English systemd Portuguese (Brazil) 7 characters edited Current translation systemd a year ago
None Suggestion added fedora-docs-l10n/quick-docs master/pages/postgresql Portuguese (Brazil)	English systemd Portuguese (Brazil) 7 characters edited Current translation systemd 3 years ago