postgresql tag

79 questions

2 answers
76 views
0

What is the difference between the psql and sql commands?

It's a beginner who started studying databases.I'm very sorry for the sudden question, but are the psql and sql commands the same? Or is it something else?I used this site as a reference.PostgreSQL Co...

linux sql postgresql

2 years ago

1 answers
154 views
0

Configuring the EC2 Rails+unicorn Launch Script

Configuring Amazon Linux+unicorn+nginx+posgtresql (RDS) environment for Rails app production.When writing unicorn startup scripts, I tried various information, but the startup failed.Environmentruby 2...

ruby-on-rails nginx postgresql unicorn

2 years ago

2 answers
86 views
0

Server Stops at pg_dump

I am currently using apache 2.2, postgresql 8.3.3, and PHP 5.3.The symptoms are as described in the heading, but the following actions are listed:·Pg_dump has been issued to back up the database in or...

php apache postgresql

2 years ago

1 answers
52 views
0

What is the difference between "separating access control by DB" and "separating access control by schema"?

This is PostgreSQL12.The PostgreSQL server uses AWS RDS.legend) User: SQL ExecutorGroup—Indicates the range of access.Assume there are DBs, schemas, and tables under the group.Group A: User 1, User 2G...

postgresql

2 years ago

1 answers
64 views
0

Understanding Date Aggregation by sql

I use postgresql.in SQL using two tables: A (date, month, quantity), B (start date, end date)select sum (quantity) as total group by month is the formula I would like to exclude the quantity between t...

sql postgresql

2 years ago

1 answers
68 views
0

Error in Logstash Output to PostgreSQL

Logstash displays the following error when outputting to Postgresql:[ERROR][org.logstash.Logstash]java.lang.IllegalAccessError: tried to access class org.postgresql.Driver$ConnectThread from class org...

postgresql

2 years ago

5 answers
49 views
0

About postgresql Acceleration

I have a question about the title.When the system processes a task for multiple users at once, it inserts the processed user's code into the log table, separated by commas, text.When searching for the...

sql postgresql

2 years ago

1 answers
55 views
0

Can connect to AWS aurora via psql, but cannot insert

I would like to install only the postgresql client on Amazon Linux and connect to Aurora for use.Aurora is postgresql. psql-host-database-U usernameYou can also connect and select from the .However, w...

aws postgresql

2 years ago

1 answers
51 views
0

Understanding How to Write the On Intra-Clause Primary Key During Self-Coupling

Nice to meet you.I have just learned SQL.I started studying using an overseas practice site, but when I was solving the questions in the link below, I came up with a question.https://pgexercises.com/q...

sql postgresql

2 years ago

1 answers
90 views
0

An error occurs when Capistrano deploys the Rails app to EC2.PG::ConnectionBad:FATAL:Peer authentication failed for user "postgres"

AW I am a beginner at AWS.Until now, I have only used Heroku.AWS Configuration1 EC2 instancePostgreSQL on RDS, one I'd like to deploy the Rails app to EC2 via Capistrano.The following Capistrano comma...

ruby-on-rails aws postgresql capistrano amazon-ec2

2 years ago

- 3 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656