Comments (9)
Finding my feet by debugging as much as I can/looking up more ways to debug S4.
A call to traceback
shows this:
from rpostgres.
After checking with the database admin and IT, I am being advised this might be due to proxy being utilised under the wraps by dbConnect (?)
Trying to debug now to see if this is the case (debugging is more complicated because simply using debug
is not very helpful)...
from rpostgres.
Thanks. Can you connect with another client, e.g., the psql
command line or a GUI?
from rpostgres.
Thanks a lot for the message, @krlmlr!
I tried telnet
if that counts. I don't have others like PgAdmin just yet, but I will ask for them to be installed so I can check.
Could you also suggest how I can see under the wraps of the dbConnect method? I tried traceback
but surely there will be better ways?
from rpostgres.
@krlmlr , I could not check via a GUI just yet, but I just checked with python using psycopg2
.
It threw the same error (perhaps unsurprisingly as it too is based on libpq
)
from rpostgres.
Thanks. I've seen cases where psql
et al. works but RPostgres doesn't. Unfortunately, if both don't work, I have to ask you to troubleshoot psql
or PgAdmin first.
from rpostgres.
Thanks @krlmlr
I and my IT have not been able to diagnose this issue yet.
Hopefully in the next couple of days IT will have installed a client like PgAdmin or psql for me to check. If not, then I will close this issue.
Many thanks for the patience, BTW!
from rpostgres.
Turns out the network team had assigned an incorrect security policy to my account due to which I was unable to connect.
Apologies for any hassle!
from rpostgres.
from rpostgres.
Related Issues (20)
- collation warning on Ubuntu 22.04 HOT 4
- Unable to create table with logical column HOT 4
- relicense RPostgres as MIT HOT 2
- using databases.pacha.dev for testing HOT 4
- Curious bug with transaction and `dbSendQuery()` HOT 6
- Schema with DBI::Id appears not to work with `dbListTables` HOT 4
- Redshift: dbWriteTable() with larger DFs and CSVs HOT 3
- Bigints in dbQuoteLiteral HOT 4
- Polygon/multipolygon columns: incorrect write, correct read HOT 7
- Something wrong with the 1.4.5 Mac binary on CRAN with Redshift HOT 33
- How to deal with `pq__varchar` columns HOT 11
- vendoring cpp11 headers HOT 1
- RPostgres should respect system timezone rather than default to UTC HOT 9
- unnamed `Id()` breaks `dbQuoteIdentifier()` HOT 10
- Option to convert "enum" types to factor or character? HOT 11
- Memory leak when querying from a packaged function HOT 3
- RPostgres dbConnect crashes with segfault in R 4.2.3 running on RHEL 8 HOT 1
- Configuration failed because libpq was not found. HOT 7
- dbGetQuery failing due to stale Redshift OIDs HOT 6
- `dbAppendTable()` is incompatible with PostgreSQL row-level security enabled (COPY FROM not supported) HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from rpostgres.