投稿時間:2023-05-04 18:08:48 RSSフィード2023-05-04 18:00 分まとめ(13件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
python	Pythonタグが付けられた新着投稿 - Qiita	[備忘録] 100MB以上のgit pushエラーについて	https://qiita.com/milkman/items/347346e3d9a6ab2635c2	findsizemls	2023-05-04 17:46:41
python	Pythonタグが付けられた新着投稿 - Qiita	【Python初学者】jsonに存在するURLから画像を一括保存し、パスをローカルに書き換える	https://qiita.com/ito_futa/items/721656487879ea5f5f88	記事	2023-05-04 17:08:48
Linux	Ubuntuタグが付けられた新着投稿 - Qiita	私が使うgotop	https://qiita.com/bugcity/items/0dac6b80b14c110d9618	pumemdisknetprocstempbatt	2023-05-04 17:27:04
Docker	dockerタグが付けられた新着投稿 - Qiita	NginxのアクセスログをFluentdでMySQLに格納して可視化	https://qiita.com/piityan1126/items/db577a53523025101052	dockercompose	2023-05-04 17:04:47
Git	Gitタグが付けられた新着投稿 - Qiita	[備忘録] 100MB以上のgit pushエラーについて	https://qiita.com/milkman/items/347346e3d9a6ab2635c2	findsizemls	2023-05-04 17:46:41
Git	Gitタグが付けられた新着投稿 - Qiita	エンジニア転職１年で本当に使ったgitコマンド	https://qiita.com/pukuku/items/423a5856356b3205506f	転職	2023-05-04 17:19:07
Ruby	Railsタグが付けられた新着投稿 - Qiita	deviseでログイン後のリダイレクトを設定したらヘルパーメソッドのundefinedエラーが発生	https://qiita.com/yuta-nos/items/3dbe8b453ab79a92b6d9	devise	2023-05-04 17:25:08
技術ブログ	Developers.IO	[レポート] マイクロサービスにおけるアプリケーション統合パターン #API303-R #reinvent	https://dev.classmethod.jp/articles/api303-r-application-integration-patterns-for-microservices-reinvent-2022/	apirreinvent	2023-05-04 08:28:47
技術ブログ	Developers.IO	【アップデート情報 / BigQuery】 テーブルのcloneがGAになりました	https://dev.classmethod.jp/articles/bigquery-clone/	bigquery	2023-05-04 08:04:50
海外TECH	DEV Community	PostgreSQL on OpenBSD: Upgrade 14 to 15 with pg_upgrade	https://dev.to/nabbisen/postgresql-on-openbsd-upgrade-14-to-15-with-pgupgrade-946	PostgreSQL on OpenBSD Upgrade to with pg upgrade SummaryOpenBSD gives us good documentation as a series of the project For example the man pages are cared and kept maintained It s applied to principal service packages as well as the OS So is as to PostgreSQL Well according to their pkg readme on PostgreSQL usr local share doc pkg readmes postgresql server they suggest we have two ways to upgrade the database pg dumpallpg upgradeThe former is slower so is not suitable for big databases but doesn t require the additional package The latter is vice versa I wrote about the former in which I upgraded PostgreSQL to It is the turn of the latter EnvironmentOS OpenBSD lt DB PostgreSQL lt TutorialHere is a step by step guide Let s begin Backup Optional When you worry about backup pg dumpall is available pg dumpall gt pg sqldump Here you will be asked by Password at the number of databases Install pg upgradeGet it via the ports package system doas pkg add postgresql pg upgradeThe result was quirks signed on T Zpostgresql pg upgrade postgresql previous p okpostgresql pg upgrade ok Upgrade OpenBSD to and PostgreSQL to It is about upgrading OpenBSD instead of PostgreSQL Run sysupgrade sysmerge and pkg add u in this order The detail is in this post Well within the process above you will be asked about PostgreSQL like below postgresql server p Updating across a major version data migration needed see the pkg readme Do you want to update now y N a yEnter y and the package not the database itself of PostgreSQL will be upgraded It will be printed out like below postgresql client postgresql contrib postgresql pg upgrade postgresql server gt postgresql client postgresql contrib postgresql pg upgrade postgresql server p ok New and changed readme s usr local share doc pkg readmes postgresql server Stop the daemonGet ready by stopping the server doas rcctl stop postgresqlThe result was postgresql ok Now we are ready Let s upgrade the database Create PostgreSQL clusterPrepare for creating the data directory doas mv var postgresql data var postgresql data Then mkdir it and initdb for PostgreSQL doas su postgresql c mkdir var postgresql data amp amp cd var postgresql amp amp initdb D var postgresql data U postgres A scram sha E UTF W doas su postgresql c mkdir var postgresql data amp amp cd var postgresql amp amp initdb D var postgresql data U postgres A scram sha E UTF locale ja JP UTF W The former above is due to the pkg readme and the latter is specific for my case in which locale option is added The result was The files belonging to this database system will be owned by user postgresql This user must also own the server process The database cluster will be initialized with locale ja JP UTF initdb could not find suitable text search configuration for locale ja JP UTF The default text search configuration will be set to simple Data page checksums are disabled Enter new superuser password Enter it again Enter the password of your PostgreSQL superuser twice Then it will be followed by the below fixing permissions on existing directory var postgresql data okcreating subdirectories okselecting dynamic shared memory implementation posixselecting default max connections selecting default shared buffers MBselecting default time zone Asia Tokyocreating configuration files okrunning bootstrap script okperforming post bootstrap initialization oksyncing data to disk okSuccess You can now start the database server using pg ctl D var postgresql data l logfile startYay The database is initiated with them generated Configure for migrationThe steps here are temporary for the data migration Edit pg hba conf of the current and also the next doas nvim var postgresql data pg hba confin order to allow local connection by the superuser TYPE DATABASE USER ADDRESS METHOD local all postgres trustNote that you should put the line at the top in order to let it be the most highly prioritized Then copy the files below including pg hba conf to the data directory of the latest doas cp p var postgresql data pg hba conf var postgresql data in addition in case that tls is used doas cp p var postgresql data server crt key var postgresql data Run pg upgradeOK Your database is now waiting for the upgrade Run the command lines thanks to the software and the pkg readme doas su postgresql c cd var postgresql amp amp pg upgrade b usr local bin postgresql B usr local bin U postgres d var postgresql data D var postgresql data The result was below in my case Performing Consistency Checks Checking cluster versions okChecking database user is the install user okChecking database connection settings okChecking for prepared transactions okChecking for system defined composite types in user tables okChecking for reg data types in user tables okChecking for contrib isn with bigint passing mismatch okCreating dump of global objects okCreating dump of database schemas okChecking for presence of required libraries okChecking database user is the install user okChecking for prepared transactions okChecking for new cluster tablespace directories okIf pg upgrade fails after this point you must re initdb thenew cluster before continuing Performing Upgrade Analyzing all rows in the new cluster okFreezing all rows in the new cluster okDeleting files from new pg xact okCopying old pg xact to new server okSetting oldest XID for new cluster okSetting next transaction ID and epoch for new cluster okDeleting files from new pg multixact offsets okCopying old pg multixact offsets to new server okDeleting files from new pg multixact members okCopying old pg multixact members to new server okSetting next multixact ID and offset for new cluster okResetting WAL archives okSetting frozenxid and minmxid counters in new cluster okRestoring global objects in the new cluster okRestoring database schemas in the new cluster okCopying user relation files okSetting next OID for new cluster okSync data directory to disk okCreating script to delete old cluster okChecking for extension updates okUpgrade Complete Optimizer statistics are not transferred by pg upgrade Once you start the new server consider running usr local bin vacuumdb U postgres all analyze in stagesRunning this script will delete the old cluster s data files delete old cluster shSuccessful Restore configurationRestore the configuration by removing the temporary line doas nvim var postgresql data pg hba conf in addition if you care about restoring the previous one doas nvim var postgresql data pg hba conflike below TYPE DATABASE USER ADDRESS METHOD local all postgres trust Configure for PostgreSQL Optional When you have specific configuration with postgresql conf etc apply them create the backup optional doas cp p var postgresql data postgresql conf var postgresql data postgresql conf org doas nvim var postgresql data postgresql conflike below for example listen addresses ssl on Besides as to postgresql conf the original one is in usr local share postgresql postgresql conf sample All on the upgrade have been done Start the daemon againLet s start the database server doas rcctl start postgresqlI hope the result is successful Remove the package Optional You are now free to farewell with appreciation to the package which worked fine doas pkg delete postgresql pg upgradeThe result was postgresql pg upgrade ok ConclusionThrough the steps above we can upgrade PostgreSQL to with upgrading OpenBSD to Besides the data directory may become old one in some future Wish you pretty happy time with the latest PostgreSQL on the latest OpenBSD	2023-05-04 08:08:11
海外ニュース	Japan Times latest articles	MSDF chief calls for closer naval cooperation amid growing security challenges	https://www.japantimes.co.jp/news/2023/05/04/national/msdf-chief-naval-cooperation/	MSDF chief calls for closer naval cooperation amid growing security challengesEnsuring free and open seas is becoming increasingly “indispensable for many countries MSDF Chief of Staff Adm Ryo Sakai Sakai said Thursday during a panel	2023-05-04 17:05:16
ビジネス	不景気.com	旅行予約支援サイト運営の「atta」に破産決定、負債1億円 - 不景気com	https://www.fukeiki.com/2023/05/atta.html	東京都港区芝浦	2023-05-04 08:04:19
海外TECH	reddit	Am I right by thinking most Japanese people don’t find stupid stuff funny?	https://www.reddit.com/r/japanlife/comments/137e5z3/am_i_right_by_thinking_most_japanese_people_dont/	Am I right by thinking most Japanese people don t find stupid stuff funny Nobody laughs when I show them family guy Same for things like Jackass I like comedy that s dumb and only makes people laugh because it s simply stupid I can t find anyone here that has the same humour For context I m and still think that poo is the funniest thing in the world submitted by u Unchigadechatta to r japanlife link comments	2023-05-04 08:18:34