Hot answers tagged

3

You cannot do this. No RDBMS allow you to keep data in S3. S3 is just an internet object store, each access need you to download the WHOLE object using particular API. It is only practical if the object is small enough to load one time and fit into the memory, e.g. something as small as sqlite that allow you to load in-memory and little to no change to the ...


2

Check and make sure postregsql is listening on your interface IP (not just 127.0.0.1). ss -ltn If not, modify the listen_addresses to * or the IP you want. These settings should be in postgresql.conf file generally located in the postgresql data directory. https://www.postgresql.org/docs/9.4/static/runtime-config-connection.html


1

I found the solution with help of a Bogdan Kuštan. It because Selinux accepts 5432 as Postgresql port and does not work with other ports. You can check acceptable ports to Selinux labeld port with semanage port -l command. You can add ports to labeled ports with "semanage port -a" command with some other parameters and in my case: semanage port -a -t ...


1

You may want to switch to (or allow) ident auth, then create a local system user with that same name. Then you can just run that script as that user, and it will log you in to postgres with that same user. https://www.postgresql.org/docs/9.0/static/auth-methods.html https://www.postgresql.org/docs/9.0/static/auth-pg-hba-conf.html So something like this ...


1

Take a look at a similar post here: Postgresql: Scripting psql execution with password The overall accepted answer (which may or may not work for your version of Postgres) is to use the PGPASSWORD environment variable like so: PGPASSWORD=[your password] psql -Umyuser < myscript.sql EDIT: Seems as though you tried and this didn't work. Have you looked ...



Only top voted, non community-wiki answers of a minimum length are eligible