BigSQL supplies a packaged PostgreSQL distribution for multiple platforms including popular extensions and tools around Postgres.
Homepage: https://www.bigsql.org/
Questions tagged [postgresql-bigsql]
7 questions
1
vote
1 answer
Is it safe to delete archive_status log file in postgresql 10
I am not a DBA but i am using postgresql for production server and i am using postgresql 10 database. I am using Bigsql and i started replication of my production server to other server and on replication server everything is working but on my…
Manish Yadav
- 435
- 2
- 8
- 24
0
votes
1 answer
Can't upload dataset to BigQuery
I'm trying to upload the dataset from this link (https://www.kaggle.com/datasets/aaditshukla/flipkart-fasion-products-dataset) on either format to BigQuery.
If I try to upload a xlsx file I get the following error:
Error while reading data, error…
0
votes
1 answer
ERROR: java.lang.ClassNotFoundException: org.apache.hive.jdbc.HiveDriver postgres Foreign data wrapper
=# SELECT code, total_emp FROM sample_07 ORDER BY code LIMIT 3;
**ERROR: java.lang.ClassNotFoundException: org.apache.hive.jdbc.HiveDriver**
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at…
vinsent paramanantham
- 953
- 3
- 15
- 34
0
votes
0 answers
How to show all servers in PgAdmin III LTS by BigSQL
Postgres PgAdmin server pane contains lot of servers.
BigSQL Postgres 10.1 was installed in Windows 10. It installed also PgAdmin III LTS by BigSQL.
In this PgAdmin server window only servers added in it are shown. For example, if server named…
Andrus
- 26,339
- 60
- 204
- 378
0
votes
1 answer
BigsqlPostgres pg_dump command using crons in ubuntu not working
I am using Ubuntu 16.04 xenial. And on ubuntu machine i installed BigsqlPostgres version 10. Which is installed in directories as follows:
BigsqlPostgres:
/etc/bigsql/pg10/bin/
/etc/bigsql/data/
I am using below scripts for taking a backup of…
Manish Yadav
- 435
- 2
- 8
- 24
0
votes
2 answers
How can i install pg96 in docker asking for password and giving error?
I have followed this https://www.openscg.com/bigsql/package-manager/ but on last command how to give password
I want to install pg96 by pgc .
Every thing worked fine pgc is installed in my syatem but when i want to install pg96 it is giving error…
Himanshu sharma
- 7,487
- 4
- 42
- 75
0
votes
0 answers
Remote access to EnterpriseDB PostgreSQL
When I install PostgreSQL from BigSQL I can connect from QGIS on other PC to my local PostgreSQL Server (both PCs are on the same local network 192.168.100.0/24). But then I can't install PostGIS because it always says $libdir/postgis-2-3 can't be…
Aleksandar
- 1,163
- 22
- 41