English 中文(简体)
我怎么做,问一下只读到Pogres(或MySql)的幻觉?
原标题:How can I make and query read only snapshots in Postgres (or MySql)?

因此,我只想在一天结束时对一个数据库进行阅读,并持续几个月。

因此,我能够对照具体(姓名)小幅提问。

能否以低廉的资源使用来实现(数据库仅作非常缓慢的改动,但数据有几类差异,因此几乎所有数据都是所有图表所共有的)。

最佳回答

通常在PogreSQL中制造一个幻觉的方法是使用pg_dump/pg_restore。

一种更快捷的方法是简单地利用CREATE DATABASE来打上你的数据库。

CREATE DATABASE my_copy_db TEMPLATE my_production_db;

这将比倾销/排泄物更快。 这一解决办法的唯一缺点是,源数据库决不能有任何公开的联系。

这份副本不会因违约而读,但你可以简单地从用户那里收回各自的特权,以确保:

问题回答

暂无回答




相关问题
摘录数据

我如何将Excel板的数据输入我的Django应用? I m将PosgreSQL数据库作为数据库。

Postgres dump of only parts of tables for a dev snapshot

On production our database is a few hundred gigabytes in size. For development and testing, we need to create snapshots of this database that are functionally equivalent, but which are only 10 or 20 ...

How to join attributes in sql select statement?

I want to join few attributes in select statement as one for example select id, (name + + surname + + age) as info from users this doesn t work, how to do it? I m using postgreSQL.

What text encoding to use?

I need to setup my PostgreSQL DB s text encoding to handle non-American English characters that you d find showing up in languages such as German, Spanish, and French. What character encoding should ...

SQL LIKE condition to check for integer?

I am using a set of SQL LIKE conditions to go through the alphabet and list all items beginning with the appropriate letter, e.g. to get all books where the title starts with the letter "A": SELECT * ...

热门标签