//转发自: @谭乔: 【谭sir与大爷】过 命 之 交
明日之后第四季:生存之战三部曲之《末日无间》
“你是为了我学会三轮车漂移的吗?”
“只能,漂一点点……“
https://api.2heng.xin/bilibili/og.php?av=719117504&high_quality=1&danmaku=0
https://t.bilibili.com/590775234063080405
今天才发现以前写的自动备份脚本忘记写密码了,于是每次pg dump实际都没有执行成功,这一年多一直就是备份了个寂寞,也幸亏今年没出现什么意外
然而真的今天跑了一次pg dumpall,发现性能开销极大(8GB的数据库,把其他所有服务停了也得20分钟才能dump完),打算以后备份策略改为直接停机压缩打包所有PostgreSQL文件
分享动态
//转发自: @eee花凋零: 【原神】新功能?待机动画竟能互动了
视频整了不少时间了 好兄弟点个赞吧
这是对UP主最大的动力,,Ծ‸Ծ,,
投币 收藏 我直接好耶 ヾ(✿゚▽゚)ノ
(EDG好样的)
https://api.2heng.xin/bilibili/og.php?av=379046340&high_quality=1&danmaku=0
https://t.bilibili.com/590691203025001479
迁移postgresql 14的时候报错有点多,回退了
,
PostgreSQL Database directory appears to contain a database; Skipping initialization,
,
2021-11-08 03:10:09.353 UTC [1] LOG: starting PostgreSQL 14.0 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit,
2021-11-08 03:10:09.353 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432,
2021-11-08 03:10:09.353 UTC [1] LOG: listening on IPv6 address "::", port 5432,
2021-11-08 03:10:09.359 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432",
2021-11-08 03:10:09.369 UTC [21] LOG: database system was shut down at 2021-11-08 03:09:59 UTC,
2021-11-08 03:10:09.377 UTC [1] LOG: database system is ready to accept connections,
2021-11-08 03:10:57.632 UTC [43] ERROR: role "postgres" already exists,
2021-11-08 03:10:57.632 UTC [43] STATEMENT: CREATE ROLE postgres;,
2021-11-08 03:11:52.879 UTC [22] LOG: checkpoints are occurring too frequently (24 seconds apart),
2021-11-08 03:11:52.879 UTC [22] HINT: Consider increasing the configuration parameter "max_wal_size".,
2021-11-08 03:12:04.023 UTC [45] ERROR: invalid input syntax for type boolean: "",
2021-11-08 03:12:04.023 UTC [45] CONTEXT: COPY mentions, line 880367, column silent: "",
2021-11-08 03:12:04.023 UTC [45] STATEMENT: COPY public.mentions (id, status_id, created_at, updated_at, account_id, silent) FROM stdin;,
2021-11-08 03:12:12.970 UTC [45] ERROR: invalid input syntax for type bigint: "c565353",
2021-11-08 03:12:12.970 UTC [45] CONTEXT: COPY preview_cards, line 534192, column id: "c565353",
2021-11-08 03:12:12.970 UTC [45] STATEMENT: COPY public.preview_cards (id, url, title, description, image_file_name, image_content_type, image_file_size, image_updated_at, type, html, author_name, author_url, provider_name, provider_url, width, height, created_at, updated_at, embed_url, image_storage_schema_version, blurhash) FROM stdin;,
2021-11-08 03:12:17.027 UTC [22] LOG: checkpoints are occurring too frequently (25 seconds apart),
2021-11-08 03:12:17.027 UTC [22] HINT: Consider increasing the configuration parameter "max_wal_size".,
2021-11-08 03:12:19.727 UTC [45] ERROR: invalid input syntax for type timestamp: "",
2021-11-08 03:12:19.727 UTC [45] CONTEXT: COPY status_stats, line 974194, column updated_at: "",
2021-11-08 03:12:19.727 UTC [45] STATEMENT: COPY public.status_stats (id, status_id, replies_count, reblogs_count, favourites_count, created_at, updated_at) FROM stdin;,
2021-11-08 03:12:33.652 UTC [22] LOG: checkpoints are occurring too frequently (16 seconds apart),
2021-11-08 03:12:33.652 UTC [22] HINT: Consider increasing the configuration parameter "max_wal_size".,
2021-11-08 03:12:51.660 UTC [22] LOG: checkpoints are occurring too frequently (18 seconds apart),
2021-11-08 03:12:51.660 UTC [22] HINT: Consider increasing the configuration parameter "max_wal_size".,
2021-11-08 03:13:11.506 UTC [22] LOG: checkpoints are occurring too frequently (20 seconds apart),
2021-11-08 03:13:11.506 UTC [22] HINT: Consider increasing the configuration parameter "max_wal_size".,
2021-11-08 03:13:27.982 UTC [22] LOG: checkpoints are occurring too frequently (16 seconds apart),
2021-11-08 03:13:27.982 UTC [22] HINT: Consider increasing the configuration parameter "max_wal_size".,
2021-11-08 03:13:49.128 UTC [74] ERROR: canceling autovacuum task,
2021-11-08 03:13:49.128 UTC [74] CONTEXT: while scanning block 62212 of relation "public.media_attachments",
automatic vacuum of table "postgres.public.media_attachments",
2021-11-08 03:13:53.847 UTC [74] ERROR: canceling autovacuum task,
2021-11-08 03:13:53.847 UTC [74] CONTEXT: while scanning block 7912 of relation "public.mentions",
automatic vacuum of table "postgres.public.mentions",
2021-11-08 03:13:55.768 UTC [74] ERROR: canceling autovacuum task,
2021-11-08 03:13:55.768 UTC [74] CONTEXT: while scanning block 2208 of relation "public.pghero_space_stats",
automatic vacuum of table "postgres.public.pghero_space_stats",
2021-11-08 03:13:57.035 UTC [74] ERROR: canceling autovacuum task,
2021-11-08 03:13:57.035 UTC [74] CONTEXT: while scanning block 2117 of relation "public.preview_cards",
automatic vacuum of table "postgres.public.preview_cards",
2021-11-08 03:14:00.123 UTC [94] ERROR: canceling autovacuum task,
2021-11-08 03:14:00.123 UTC [94] CONTEXT: while scanning block 39950 of relation "public.statuses",
automatic vacuum of table "postgres.public.statuses",
2021-11-08 03:15:33.147 UTC [22] LOG: checkpoints are occurring too frequently (24 seconds apart),
2021-11-08 03:15:33.147 UTC [22] HINT: Consider increasing the configuration parameter "max_wal_size".,
2021-11-08 03:15:37.676 UTC [125] ERROR: canceling autovacuum task,
2021-11-08 03:15:37.676 UTC [125] CONTEXT: while scanning block 213998 of relation "public.statuses",
automatic vacuum of table "postgres.public.statuses"
分享动态
//转发自: @-MeilleurEager: 2003年 18岁的艾薇儿在韩国演唱了首专神曲《tomorrow》
#欧美现场 #艾薇儿 #AVRILLAVIGNE
那一年她发了首专《letgo》一夜爆红
那时候的艾薇儿风吹起她的头发是青春最美好的样子
https://api.2heng.xin/bilibili/og.php?av=56812563&high_quality=1&danmaku=0
https://t.bilibili.com/590054843496125887
分享动态
//转发自: @风清凉QAQ: 干货!【王者荣耀世界】啥都没做出来!宣传片抄袭怪物猎人误导玩家!
-
https://api.2heng.xin/bilibili/og.php?av=718880959&high_quality=1&danmaku=0
https://t.bilibili.com/589868179921567771
据说是一个比elasticsearch高效的搜索引擎,自带中文支持
https://github.com/valeriansaliou/sonic
Particles From the Sun Produce Light Show on Earth
#NASA #ImageOfTheDay The aurora borealis glow on the northern horizon while stars wheel overhead in this long exposure, taken near the Bonneville Salt Flats in Utah on Nov. 4, 2021.
http://www.nasa.gov/image-feature/particles-from-the-sun-produce-light-show-on-earth
Gamma Ray Ghouls!
#NASA #ImageOfTheDay Take a tour of some of the most terrifying and mind-blowing destinations in our galaxy ... and beyond.
Chinese 🇨🇳 / Dictatorial Admin / Mastodon Code Contributor / 摸鱼技术布道师
Steam: https://steamcommunity.com/id/MashiroBest
Epic: https://store.epicgames.com/en-US/u/d211c824cbd94aaeba898db6bb823ff7
原批交流群:966322309