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,922 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
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
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))
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
-
Updated
May 25, 2020
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
Apr 3, 2020 - Go
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
Jun 24, 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" : { "
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.
-
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
Ref #1101 we've concluded to remove the MyGet feed, which has been used for pre-releases up until now. That involves several tasks. From the top of my head:
- Move all NuGet packages currently on the MyGet feed over to the Azure Artifacts feed
- Update readme.md to show a badge for the latest release on the new feed and remove MyGet
- Delete the Travis build script all together, or
-
Updated
Jun 17, 2020 - Ruby
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>
See #2269
-
Updated
May 28, 2020 - Perl
Created by Michael Stonebraker
Released July 8, 1996
- Repository
- postgres/postgres
- Website
- www.postgresql.org
- Wikipedia
- Wikipedia
Steps to reproduce:
On a template variable with multi-select:
Actual Result:
The space bar input is appended or prepended to the search text.
Expected Result
The search text should remained unchanged, since focus is on a dropdown item.
**Releva