I installed the latest pgAdmin 4 (v2.1) but I found out that (related thread ), for the moment, the only way to establish a connection through an SSH tunneling is using another outside process, an example in the pgAdmin's forum says: > I setup a tunnel as follows: > > ssh -f dpage(at)hostname(dot)enterprisedb(dot)com -L 5999: hostname.enterprisedb.com:5432 -N > > (...) I was running on Mac, but the same procedure should work on Linux. On Windows, there's a tunnelling app in Putty iirc, but I don't know how to use it offhand. I have found a simple PuTTY tutorial to establish a connection using an SSH Tunnel . The connection is established but it seems, when I try to connect through pgAdmin it fails or is refused (using _127.0.0.1:3306_ or _127.0.0.1:5432_ as the tunnel's destination). Why?

I have a containerized setup of pgAdmin4 V8.5 in server mode running. Does anyone know if I can create groups for local users in pgadmin4 in web server mode and set privileges for them? Basic idea To have one user with administrative privileges and who would have a list of databases (by server.json and .pgpass files) and give access by sharing database to individual groups or users. For example pgadmin4 has 3 users: - user admin@example.com has a list of 3 Postgresql databases (DB1, DB2 and DB3) and is in the admins group - user user1@example.com is in the readers group - user user2@example.com, is in the writers group User admin@example.com shares DB1 only to the readers group and DB2 only to the writers group. Users user1@example.com and user2@example.com avoid having to manually configure database connections when authorizing in pgadmin4 and get the list of databases from user admin@example.com. Maybe does anyone know any forks pgadmin4 (server mode) or any another applications which supports this idea I'd appreciate the information! Thanks in advance!

I'm used to HeidiSQL, where your tabs and their states are always remembered and come back when you reopen the program. Can pgAdmin4 automatically reopen the tabs used in its last run?

There is something in the MySQL console that drives me nuts. When I hit ctrl+c to cancel the current command being typed, the terminal exits. In every terminal I know (*nix terminals, Python, PostgreSQL), ctrl+c cancels the current command and ctrl+d exits the terminal. This issue has been reported at 2003 , and bumped several times since. Is there a way to: * Change this behaviour, or * Convince the MySQL dev team that this is really annoying?

I would like to upgrade a PostgreSQL 8.3 server to PostrgreSQL 8.4. There are many software components that interact with the server over the network, and I am concerned with compatibility issues. Is there any interface change between the different versions of PostgreSQL, as far as an external component is concerned?

Hi I'm currently working on a project that involves a third party database and application. So far we are able to successfully **TEST** and interface data between our databases. However we are having trouble when we are extracting a large set of data (ex 100000 rows and 10 columns per row) and suddenly it stopped at the middle of transaction for whatever reason(ex blackouts, force exit or etc..), missing or duplication of data is happening in this type of scenario. Can you please give us a suggestions to handle these types of scenarios. Here's our current interface structure - OurDB -> Interface DB -> 3rdParty DB - OurDB: We are extracting records from OurDB (with bitcolumn as false) to the InterfaceDb - InterfaceDB: After inserting records from OurDB, we will update OurDB bitcolumn as true - 3rdPartyDB: They will extract and delete all records from InterfaceDB (they assume that all records is for extraction)

I've recently been given access to a mySQL database which will sit behind a website designed to allow people to register their interest in a given subject and provide further information about themselves. Of course the password is hashed/salted, but both the answers to the security questions are stored in clear text. When I questioned this I was told that the website couldn't retrieve the answers if they were hashed, and since the same website is used by the helpdesk to verify peoples details if they contact them it is necessary for the helpdesk staff to be able to read the answers. I am completely new to the security/website interaction side of things, so I don't even know where to start querying this. So my questions are as follows: Is it likely that there is a technical issue that prevents the site from dealing with hashed information (I'm told the website has been developed in Google Apps)? Where can I find resources that will help me argue for the further development of the site/app so that it can deal with hashed information? Am I just being paranoid? Thanks, Anne PS I hope this is the right forum for this, otherwise please let me know and I'll remove the post (that's how new I am to this), same goes for editing tags.

I need some advice before we engage in some costly development work We have two SQL Server database servers on the same network. One runs an in house database and the other a proprietary database that we bought in. We want a couple of tables between the two to be synchronised (customer details / contact details) Now if I were doing this I would create a trigger on a table in database A that when updated calls a stored procedure that updates a table in database B. And vice versa to keep the records in synch with an appropriate flag that activates the trigger. The creators of the proprietary database that we need to interface with have proposed creating a network service that picks up changes in our database and extracts the data back to their own. And the transfer can only be one way by their service because of 'record locking'. Without making any assumptions is this really the best way to do things? Thanks NB both databases are running on SQL SERVER 2005