我无法通过psql -h *EC2ExternalIP* -U *me*之类的方式访问远程access数据库。我会得到:
psql -h *EC2ExternalIP* -U *me*
psql: could not connect to server: Operation timed out
Is the server running on host *EC2ExternalIP* and accepting
TCP/IP connections on port 5432?
与尝试连接此端口的简单telnet连接相同:
curl telnet://*EC2ExternalIP*:5434
c
我用我的.sql文件创建了一个数据库,如下所示:
CREATE SEQUENCE ec_account_id
start 1
increment 1;
create table ec_account
(id serial PRIMARY KEY,
name VARCHAR(40) not null,
password VARCHAR(80) not null,
email VARCHAR(30) not null,
phone VARCHAR(10) not null);
inser