Questions tagged [remote]
The remote tag has no usage guidance.
137
questions
1
vote
0
answers
221
views
Restore postgresql database from remote sql file
I would like to know if it's possible to restore a database from a remote sql file.
The problem:
- Working with PostgreSQL 9.2.4
- I have an small remote server with 10GB left in storage
- I have a ...
- 113
0
votes
1
answer
73
views
How to connect to remote MySQL server with sshuser and mysqluser being distinct
I'm trying to connect to a remote MySQL server via ssh so that I have write-access to export some data. At the moment I can do the following:
Connect to the remote MySQL using mysql -u mysqluser -...
- 135
3
votes
2
answers
5k
views
MySQL remote connection: Public vs. private IP address
I just went through the obligatory pain of getting MySQL to accept a remote login. Yes, I had to create a user of the form ''@'%', and I did so. Yes, I had to GRANT ALL ON . to my new '@%' user and ...
- 31
1
vote
1
answer
284
views
I need to copy data from remote Postgres server that has limited disk space and limited connectivity to a server
I have a remote Postgres server recording some data every second. the server has very less space like 6-7 GB, currently I write data to a remote VM server but due to poor connectivity the applications ...
- 21
1
vote
2
answers
2k
views
PostgreSQL 9.3 - standard_confirming_strings option in postgresql.conf not affecting remote machine
I am updating a program at work that communicates with a postgreSQL 9.3 database. I need to turn off an option in the postgresql.conf file called standard_conforming_strings, so that I can store ...
- 143
1
vote
1
answer
214
views
Connecting to a remote Postgres 9.1 DB
I am running Postgres 9.1 on Ubuntu.
I have host all all my.ip.address/32 md5
set in pg_hba.conf and listen_addresses= '*' set in postgresql.conf.
Running show listen_addresses shows '*'
Running sudo ...
- 11
1
vote
1
answer
17k
views
Execute stored procedure in another server from sql agent job
I am trying execute stored procedure in remote server in sql agent job using sqlserver 2008 r2
select * from openquery([1.1.1.1],'exec [DB_Name].[dbo].[sp_ProcName]')
Or
EXEC [1.1.1.1].[DB_Name]....
- 11
0
votes
1
answer
1k
views
remote connection to mysql
have two machine PC#1 with db mysql and appache and PC#2 with a c# form try to connect to this db
here is my connection string used in PC#2: SERVER=My_public_ip;PORT=3306;DATABASE = my_test; UID = ...
- 103
0
votes
2
answers
9k
views
Accessing Shared Folder Using Oracle Database
I have two machines A & B. I shared a folder from machine B and mapped it as a drive on machine A. Now I want to configure my Oracle Database in Archive Log mode and want to set the Archive ...
- 75
3
votes
2
answers
7k
views
What port is used by SQL Server to write backups to a remote server?
I have a SQL Server 2008 R2 Standard instance in a "DMZ", so that it can be client-facing. I am trying to have it write its backups to a central location that is within the network. The engineers ...
- 263
1
vote
1
answer
200
views
Remote SSIS development
I'm currently developing SSIS packages which include transferring data between two servers. The servers are in the same local LAN, but I'm remote to them.
Is there any way that I can develop the ...
- 231
2
votes
1
answer
20k
views
PostgreSQL isn't listen on 5432 in Windows 7 [closed]
I have a PostgreSQL 9.3.1 DB Server running in Windows 7 Ultimate. I have checked the file postgresql.conf and this lines are uncommented:
listen_addresses="*"
port=5432
And this is the ...
- 195
7
votes
2
answers
43k
views
Connecting to an external database with pgAdmin III
I'm trying to connect to an external database from pgAdmin III (which is installed on both machines).
The client complains:
Access to database denied
The server doesn't grant access to the ...
- 207
7
votes
1
answer
10k
views
How to insert in table from remote stored procedure without creating a distributed transaction?
How can I insert in a local table from a remote stored procedure without creating a distributed transaction? I want to run a stored procedure on a remote server and use the output as the source for an ...
12
votes
2
answers
13k
views
Having a PostgreSQL database exposed to the internet
I've seen on DBA and other sites that exposing a database to the Internet is a particularly bad idea, but I noticed that PostgreSQL has SSL-certificate-only authentication. Does this make it any safer ...
- 375
1
vote
1
answer
3k
views
Executing local scripts against remote server?
I am in a situation where I would like to execute a number of sql scripts that are on my local machine against a remote MySQL instance. I found this question which seems to point me in the right ...
- 459
5
votes
2
answers
3k
views
Federated tables and triggers
This is the scenario.
Have two MySQL servers (S1, S2) on different machines, with a database on each (DB1, DB2).
I have a table (T2) on DB2 that needs to "fetch" rows from another table (T1) on DB1.
...
- 53
1
vote
0
answers
232
views
Materialized view for a yet-to-be-defined DBlink
In our product we have a main application with an oracle 11g DB and an optional module with another DB.
We want the two to communicate through a dblink and I was told to put some code for the ...
- 281
1
vote
1
answer
4k
views
Slow queries to remote PostgreSQL db
I am running a Drupal site that is backed by Postgres. This is my first time running something with Postgres; I come from the MySQL world.
For doing dev work on the site, I connect to a VPN and ...
- 113
10
votes
2
answers
40k
views
Server requested authentication method unknown to the client [mysql_old_password]
Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password]
SQLSTATE[HY000] [2054] The server requested authentication method unknown to the ...
- 265
3
votes
1
answer
14k
views
Cannot connect remotely to sql server 2012 instance using SSMS
I have installed sql server 2012 Express on a local network machine, then added a new login: "sqlUser" mapped to "database1", and configured the instance to accept the remote access with both Windows ...
- 133
0
votes
2
answers
538
views
Remote database connection problem?
I have two systems with Windows XP. I have installed SQL Server 2005 on a system and tried to use SQL Server Management Studio Express on both to use the database.
I am able to use the database on ...
- 179
3
votes
1
answer
11k
views
DB2 Defining remote database alias
I'm using DB2 9.7.0.3 for AIX.
I want to select data from a remote database, also running DB2 9.7.0.3 for AIX, and insert it into the local database I'm connected to.
I believe the query for this ...
- 45
6
votes
4
answers
8k
views
Connect to SQL Server behind NAT from remote machine
The scenario is that this is a SQL Server behind a corporate firewall with your standard setup to allow only minimal outbound traffic and zero inbound. However, port 80/443 are open, per the usual ...
- 4,330
1
vote
2
answers
3k
views
Connection to MySQL Remotely
I want to connect to MySQL Server hosted on a Linux Machine from my Windows Machine using Command Prompt with the following command:
prompt>mysql -u root -p -h remote_hostname
Connections, ports, ...
3
votes
0
answers
2k
views
Timeout on remote query over database link
We are trying to verify if a database link is up before inserting data into a remote database. We have no control over the remote database's behavior and status. We need to set a timeout on a query ...
- 31
1
vote
1
answer
6k
views
I would like to launch a pg_dump command from a remote computer
I would like to launch the command: pg_dump.exe -h 255.255.255.255 -p 5432 -U postgres -F p -a -v -f "test.db.dump" mydb from a remote computer. Both the database and the remote computer are under xp.
...
- 8,651
2
votes
2
answers
8k
views
Connecting remote MySQL database to local MySQL database?
I want to write PHP code to be embedded in a Drupal7 module.
I want to call a procedure which can copy newly generated data in the local MySQL database to a remote MySQL database.
When data is ...
- 23
0
votes
3
answers
800
views
Can a RDBMS connect to a remote server, execute a select query and copy them into a local table just with SQL commands?
I'm sorry it may sound stupid but I've been wondering about how multiple databases are automated before the virtualization era. Can a DB Adminsitrator make a stored procedure to get data from a remote ...
- 707
1
vote
2
answers
2k
views
Remote to a remote oracle server and get running instances?
I need to make a shell script that takes a list of servers and and check the running instances then run sql script in each instance!
now I do not want it to ask me for a password!
it's redhat and ...
- 357
12
votes
4
answers
15k
views
Slow remote SELECT statement due to long "client processing time", but fast locally
While connected to our production server (SQL Server 2008, very powerful machine), this SELECT statement takes 2 seconds, spitting back all fields (4 MB of data in total).
SELECT TOP (30000) *
FROM ...
- 323
16
votes
2
answers
98k
views
How to add a user with access to a single view?
I'm working with MSSQL Server Management Studio 2008 and I need to expose a view to a third party for their data reconciliation. I have created the appropriate view but I'm having trouble creating a ...
- 161
6
votes
3
answers
21k
views
How to connect to remote PostgreSQL server
I wrote a web app, using java + spring+ PostgreSQL, which I have up and running.
I have a tester for my system and I want him to be able to connect to my database directly to check the result of ...
- 221
2
votes
2
answers
285
views
Connecting to SQL Server 2008 on windows server 2008
Hell all
I am new to windows server 2008 and we are trying to transfer our website from hosting to virtual server.
I installed SQL Server 2008 Express edition and I did the things like opening port ...
- 51
3
votes
2
answers
557
views
What do I need to sync a local site office SQL Server with the Head Office SQL Server
The company has a desktop application powered by SQL Server from the head office that is dependent on an internet connection to our remote sites. Usually when we move to a new site there is a good ...
- 247
3
votes
1
answer
285
views
Remote Database Backup [closed]
I am attempting to find a reliable service that does remote MySQL Database Backup.
Price is no object, unless it's absurdly expensive. I understand this question doesn't really have an answer, and I ...
- 323
5
votes
1
answer
11k
views
Remote Debugging
I'm having an issue with remote debugging. I have a non-domain server and a non-domain client PC. The client PC can successfully connect to the server and the instance, and it even runs SSMS as the ...
- 42.2k