Post AH6xE85AvXvZtuSWZ6 by razzlom@mastodon.social
(DIR) More posts by razzlom@mastodon.social
(DIR) Post #AH6st6IvwXy8UKbzFI by razzlom@mastodon.social
2022-03-05T17:26:49Z
0 likes, 0 repeats
Походу писец, дамп не восстанавливается... Я хз что делать...
(DIR) Post #AH6st6kwGQN1tBiLtg by puniko@mk.absturztau.be
2022-03-05T17:51:46.353Z
0 likes, 0 repeats
@razzlom@mastodon.social :thinking_ai: what is the output on the restore?
(DIR) Post #AH6suAdnJ1s6E8sZvM by yura@udongein.xyz
2022-03-05T17:50:16.318658Z
0 likes, 0 repeats
@puniko Can you help @razzlom with restoring Misskey from backup?
(DIR) Post #AH6suB4NiB8fYbJoMi by puniko@mk.absturztau.be
2022-03-05T17:51:56.453Z
0 likes, 0 repeats
@yura@udongein.xyz @razzlom@mastodon.social i can try, but i can't promise anything
(DIR) Post #AH6ve6ITzJ8Bz5wKTA by razzlom@mastodon.social
2022-03-05T18:20:04Z
0 likes, 0 repeats
@puniko Many errors like this:psql:dumpfile:17317592: ERROR: insert or update on table "poll_vote" violates foreign key constraint "FK_aecfbd5ef60374918e63ee95fa7"
(DIR) Post #AH6ve7u60woQy2Xsjg by puniko@mk.absturztau.be
2022-03-05T18:22:37.005Z
0 likes, 0 repeats
@razzlom@mastodon.social have you tried the --disable-triggers option on pg_restore ?
(DIR) Post #AH6vj0GXq6DEj7N4ee by puniko@mk.absturztau.be
2022-03-05T18:23:29.818Z
0 likes, 0 repeats
@razzlom@mastodon.social mmmh, Please note that this only is valid for a --data-only restore and requires the --superuser=username option to be passed, as well.https://dba.stackexchange.com/questions/23000/disable-constraints-before-using-pg-restore-exe
(DIR) Post #AH6vjWa9giuexCnBfE by puniko@mk.absturztau.be
2022-03-05T18:23:37.591Z
0 likes, 0 repeats
@razzlom@mastodon.social i hope this helps
(DIR) Post #AH6w8EsuckCjJ1Lnay by razzlom@mastodon.social
2022-03-05T18:25:17Z
0 likes, 0 repeats
@puniko I've made pg_dumpall > dumpfileand now try topsql -f dumpfile postgres
(DIR) Post #AH6w8FMKrLjwmH7ISO by puniko@mk.absturztau.be
2022-03-05T18:28:04.669Z
0 likes, 0 repeats
@razzlom@mastodon.social what about this?http://koo.fi/blog/2013/01/08/disable-postgresql-triggers-temporarily/
(DIR) Post #AH6xE7ZcoqgsK3hKO8 by razzlom@mastodon.social
2022-03-05T18:33:44Z
0 likes, 0 repeats
@puniko How to use this with command i send you earlier?
(DIR) Post #AH6xE85AvXvZtuSWZ6 by razzlom@mastodon.social
2022-03-05T18:38:38Z
0 likes, 0 repeats
@puniko psql --set session_replication_role=replica -f dumpfile postgressame error
(DIR) Post #AH6xE8XXE6c3JrjAlk by puniko@mk.absturztau.be
2022-03-05T18:40:22.189Z
0 likes, 0 repeats
@razzlom@mastodon.social :woozy_sob: how many databases are in that dumbfile? if its only one, you could try a pg_restore maybe?
(DIR) Post #AH6xJsE0nWWcSPKblQ by vib@snug.moe
2022-03-05T18:41:24.703Z
0 likes, 0 repeats
@puniko@mk.absturztau.be @razzlom@mastodon.social sorry to interrupt puni butdumbfile:blobcatlul:
(DIR) Post #AH6xKApXcjEyA11plA by puniko@mk.absturztau.be
2022-03-05T18:41:26.204Z
0 likes, 0 repeats
@razzlom@mastodon.social also i'm not sure what format the dumbfile is. but if its plain text with all the db statements, you could edit it to add those lines at the top and the bottom, i guess
(DIR) Post #AH6xMDaMLpYdHhu0EC by puniko@mk.absturztau.be
2022-03-05T18:41:50.196Z
0 likes, 0 repeats
@vib@snug.moe @razzlom@mastodon.social :swiss_fondue: :blobcatshrug: not a native english speaker
(DIR) Post #AH6xRS5PreunhqvNcO by razzlom@mastodon.social
2022-03-05T18:41:31Z
0 likes, 0 repeats
@puniko What if i just rsync /var/lib/postgresql ?
(DIR) Post #AH6xRSZu2JIlEPBj8a by puniko@mk.absturztau.be
2022-03-05T18:42:44.367Z
0 likes, 0 repeats
@razzlom@mastodon.social oh right, you are moving servers, right?that might work
(DIR) Post #AH6xVPSbZO2SiierHE by puniko@mk.absturztau.be
2022-03-05T18:43:28.267Z
0 likes, 0 repeats
@razzlom@mastodon.social i never tried it tho, but i remember isi moving the db around like that for princess.cat (i might be wrong with that tho)its worth a try tho
(DIR) Post #AH88dH8PhYaXrx7vGa by puniko@mk.absturztau.be
2022-03-06T08:22:52.469Z
0 likes, 0 repeats
@razzlom@mastodon.social did it work?
(DIR) Post #AH89n5MARmtIBpnlnU by razzlom@mastodon.social
2022-03-06T08:32:28Z
0 likes, 0 repeats
@puniko Yes, almost. Could these errors be due to an incorrect system locale? Because I had to change it to en_US.UTF-8.
(DIR) Post #AH89n5pwf4i5gBjYDA by puniko@mk.absturztau.be
2022-03-06T08:35:50.022Z
0 likes, 0 repeats
@razzlom@mastodon.social that could be. the errors itself are due to the triggers on foreign keys detecting conflicts. whatever causes that conflict can have many reasons.