postgres

PostgreSQL is a database management system that is object-relational. PostgreSQL originated from the Ingres project at the University of California, Berkeley.
Here are 2,784 public repositories matching this topic...
When adding a new data store database in Metabase it tries to connect first with SSL (if the driver supports SSL), and then without, in that order. If either connection succeeds, the database details are accepted as valid. Yes, you can add driver specific JDBC options to use SSL, but there is no good feed
Is your feature request related to a problem? Please describe.
Deployed Parse server using k8 and used /parse/health for the readinessProbe and livenessProbe probe. But when deploy new code and broke the database connection, /parse/health still returns 200 OK. So old container was killed and new broken one brought online
Describe the solution you'd like
Only return 200 ok after db is
The search functionality in the Data & Schema Management of Hasura seems to filter records considering the case of letters as well.
If this was an intended functionality, it's still better to show the tables which match the filter condition and don't match the letter-case below the tables that match with the exact letter-case.
I'm submitting a ...
- bug report
- [ X] feature request
- question
PostGraphile version: 4.4.4
postgraphile should honor variables in query string as defined in https://github.com/graphql/express-graphql#http-usage when the query is provided as post body.
with the following exampl
pgcli depends on humanize
which is https://github.com/jmoiron/humanize.
The current version has a slightly odd behavior of rounding down unexpectedly:
In [11]: humanize.naturaltime(datetime.timedelta(seconds=120))
Out[11]: '2 minutes ago'
In [12]: humanize.naturaltime(datetime.timedelta(seconds=119.9))
We are suddenly running out of background workers and were told on Slack to increase timescaledb.max_background_workers
from 8 to 16.
The documentation makes it seem like the timescaledb-tune tool will automatically set the key to a correct value. However the tool [always sets the value to 8](https://github.com/timescale/timesca
Hello @brianc,
I am working with @pspi on a modification of node-pg-copy-streams
(cf brianc/node-pg-copy-streams#91) and it could be an opportunity to improve some things in this module.
Can you share with us your ideas about coding style / dev tooling for the modules related to pg ? Do you have written something on this somewhere ? I think that all these modules
Documentation?
Is the README the only documentation available for this project? I find myself having to read the source to understand the interface and features that are available (e.g., context managers, bulk_query
, etc.).
In the case of bulk_query
, the arguments are simply passed through to the underlying SQLAlchemy engine, with no explanation. I tracked it down in [SQLAlchemy's documentation](https:/
-
Updated
May 22, 2020
for example,i want the Name
field search with name like 、> 、<、 is null、 ...
,not only name = ?
type Dapp struct {
UUID string `xorm:"varchar(36) 'uuid'"`
Name string
Subtitle string
Category string
Permission string
Synopsis string
Score float64
Logo string
Banner string
Snapshot string
Video
App v2.2.5. And a great project! Some Day 1 feedback after my move from Homebrew...
Feature Requests: (1) Status via a grey (as per Bluetooth/Wi-Fi) menu bar icon if servers are or have been stopped, as a solid black icon seems jarring (2) Server Settings > An icon to copy the data_directory to the clipboard.
Bugs: (1) Shortly after installing, the dropdown UI from the menu bar can stay semi
1、我最近在使用Enterprisedb 10.4,然后参照下面的文章:https://www.enterprisedb.com/docs/en/10.0/Ora_Reference_Guide_v10/Database_Compatibility_for_Oracle_Developers_Reference_Guide.1.035.html
在pg admin里面输入了下面这些代码
CREATE DATABASE LINK chicago
CONNECT TO sue IDENTIFIED BY 'mypassword'
USING oci '//127.0.0.1/acctg';
但是却报了下面这个错,很疑惑,语法都是按照文档上来的,为什么会有这个问题呢
ERROR: syntax error at or near "TO"
SQL state: 4
Is your feature request related to a problem? Please describe.
Provide help in CLI for sub-commands
Describe the solution you'd like
Sub-commands help should describe the sub-command's functionality and options available for the sub-command
Describe alternatives you've considered
N/A
Additional context
See: golang-migrate/migrate#370
Citus_indent setup
The steps described in our README does not work for me: https://github.com/citusdata/citus/blob/master/CONTRIBUTING.md#following-our-coding-conventions
The main problem is that after cloning the tools
repo we need to run make install
from top level instead of uncrustify
because many of the variables are defined at the top level.
According to the postgresql documentation on https://www.postgresql.org/docs/current/static/continuous-archiving.html section 25.3.3.1 you can pass 2 extra parameters to pg_start_backup()
.
I'm particularly interested in the second parameter which does a fast checkpoint.
Is this a feature which can be added as a command-line parameter to wal-e backup-push
eg `wal-e backup-push --fast-chec
Allow debug logging
requeryVersion = '1.6.0'
requeryVersion = '1.6.1'
E/BaseViewModel: java.sql.SQLNonTransientConnectionException
io.requery.PersistenceException: java.sql.SQLNonTransientConnectionException
at io.requery.sql.EntityDataStore.checkConnectionMetadata(EntityDataStore.java:588)
at io.requery.sql.EntityDataStore$DataContext.getTransactionMode(EntityDataStore.java:747)
-
Updated
May 23, 2020 - JavaScript
ZomboDB version: 4.0
Postgres version: 11.6
Elasticsearch version: 6.5.2
Problem Description:
I'd like to get results back from arbitrary_agg, but it only returns the document count. Or I'm doing something wrong?
SELECT *
FROM zdb.arbitrary_agg(
'spotlite_zdx',
dsl.match_all(),
'{
"messages" : {
"filters" : {
"filters" : [
{ "term" : { "
-
Updated
Mar 3, 2019
- pREST version (or commit ref): 3.4
- pREST endpoint: /DB0001/public/test?Auto%20ID=25
- PostgreSQL version: 10.6
- Operating system: Linux
- Go version: bundled in release
- Log gist: https://gist.github.com/baybal/c6059538121443aaad2dddf17108aead
Description
Attempting to filter of select a field with a white space results in invalid identifier error
`{
"error": "could not pe
-
Updated
May 18, 2020 - Ruby
Export events as CSV
Is your feature request related to a problem? Please describe.
I want to export a list of events as CSV.
Describe the solution you'd like
Whenever there's an EventTable, I'd like a button to export the currently filtered list by CSV.
Additional context
This should be pretty easy, see #441. It is worth putting in a sensible limit (10k?) to avoid exporting the entire database.
See #2269
-
Updated
May 18, 2020 - Perl
https://docs.rs/geo
https://www.postgresql.org/docs/current/datatype-geometric.html
POINT
->geo::Coordinate<f64>
LINE
->geo::Line<f64>
LSEG
->geo::Line<f64>
BOX
->geo::Rect<f64>
PATH
->geo::LineString<f64>
POLYGON
->geo::Polygon<f64>
-
Updated
Jan 5, 2019 - JavaScript
Created by Michael Stonebraker
Released July 8, 1996
- Repository
- postgres/postgres
- Website
- www.postgresql.org
- Wikipedia
- Wikipedia
When viewing a list of variables, each row has an ambiguous element labeled "duplicate." The user may not know if this is a tag or status indicator using "duplicate" as an adjective/noun to describe the variable as having a conflict with something else or