转储文件不应用于数据库(Rails,PostgesQL)
我正在将数据库备份文件应用于我的Rails项目, 中并未创建对象
但是我的数据库(dump(备份)文件是项目的根源)
:我的回溯: 抱歉,如果它太大,请削减很多
$ rake db:drop
Dropped database 'project_development'
Dropped database 'project_test'
$ rake db:create
Created database 'project_development'
Created database 'project_test'
$ psql project_development<dump
SET
SET
SET
SET
SET
set_config
------------
(1 row)
SET
SET
SET
SET
SET
SET
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
ALTER TABLE
COPY 0
COPY 1
COPY 1
COPY 0
COPY 4
COPY 40
COPY 0
setval
--------
1
(1 row)
setval
--------
1
(1 row)
ALTER TABLE
CREATE INDEX
ALTER TABLE
一切成功,但是数据没有出现
$ rails c
Contact.all
Contact Load (0.5ms) SELECT "contacts".* FROM "contacts" LIMIT $1 [["LIMIT", 11]]
=> #<ActiveRecord::Relation []>
I am applying a database backup file to my Rails project,
but objects are not created in my database
(The dump (backup) file is at the root of the project)
My backtrace:
sorry if it's too big, cut a lot
$ rake db:drop
Dropped database 'project_development'
Dropped database 'project_test'
$ rake db:create
Created database 'project_development'
Created database 'project_test'
$ psql project_development<dump
SET
SET
SET
SET
SET
set_config
------------
(1 row)
SET
SET
SET
SET
SET
SET
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
ALTER TABLE
COPY 0
COPY 1
COPY 1
COPY 0
COPY 4
COPY 40
COPY 0
setval
--------
1
(1 row)
setval
--------
1
(1 row)
ALTER TABLE
CREATE INDEX
ALTER TABLE
Everything is successful, but the data does not appear
$ rails c
Contact.all
Contact Load (0.5ms) SELECT "contacts".* FROM "contacts" LIMIT $1 [["LIMIT", 11]]
=> #<ActiveRecord::Relation []>
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
转储文件可能是空的。检查其大小,文件本身中的数据是否正确,是否正确。就我而言,很可能这解决了问题
There is a possibility that the Dump file is empty. Check its size, the presence of data in the file itself, whether the format is correct. In my case, most likely this solved the problem