postgresql Archives - Page 13 of 21

What’s the fastest way to do a bulk insert into Postgres?

I need to programmatically insert tens of millions of records into a Postgres database. Presently I am executing thousands of insert statements in ...

May 16, 2022
0 Comments

DatabaseError: current transaction is aborted, commands ignored until end of transaction block?

I got a lot of errors with the message : "DatabaseError: current transaction is aborted, commands ignored until end of transaction block" after ...

May 15, 2022
0 Comments

PG::ConnectionBad – could not connect to server: Connection refused

Every time I run my rails 4.0 server, I get this output. Started GET "https://stackoverflow.com/" for 127.0.0.1 at 2013-11-06 23:56:36 -0500 PG::ConnectionBad - ...

May 15, 2022
0 Comments

Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL

I want to extract just the date part from a timestamp in PostgreSQL. I need it to be a postgresql DATE type so ...

May 14, 2022
0 Comments

How do I modify fields inside the new PostgreSQL JSON datatype?

With postgresql 9.3 I can SELECT specific fields of a JSON data type, but how do you modify them using UPDATE? I can’t ...

May 14, 2022
0 Comments

Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question ...

May 14, 2022
0 Comments

How to generate the “create table” sql statement for an existing table in postgreSQL

I have created a table in postgreSQL. I want to look at the SQL statement used to create the table but cannot figure ...

May 14, 2022
0 Comments

How to persist data in a dockerized postgres database using volumes

My docker compose file has three containers, web, nginx, and postgres. Postgres looks like this: postgres: container_name: postgres restart: always image: postgres:latest volumes: ...

May 14, 2022
0 Comments

Best practices for SQL varchar column length [closed]

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be ...

May 14, 2022
0 Comments

Postgres – FATAL: database files are incompatible with server

After restarting my MacBook Pro I am unable to start the database server: could not connect to server: No such file or directory ...

May 13, 2022
0 Comments