Zen

Translation

English type: Title ===
systemd
7/100 · 7

Sign in to save translations.

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
 
User avatar anonymous

Suggestion added

systemd

Suggested change:

systemd

Failing checks:

Unchanged translation 2 years ago

Loading…

User avatar anonymous

Suggestion added
systemd
systemd
2 years ago
User avatar farribeiro

Marked for edit
systemd
systemd
2 years ago
User avatar farribeiro

Suggestion removed
systemd
systemd
2 years ago
User avatar None

Suggestion added
systemd
systemd
4 years ago
Browse all string changes

Things to check

Suggestions

There is 1 suggestion for this string.

View

Unchanged translation

Source and translation are identical

Reset

Glossary

English Portuguese (Brazil)
No related strings found in the glossary.

6389823 String information

Source string description
type: Title ===
Flags
no-wrap
Source string location
pages/postgresql.adoc:179
String age
4 years ago
Last updated
a year ago
Source string age
5 years ago
Translation file
po/pt_BR/master/pages/postgresql.po, string 56