Do I need pg_dump if DB is already on a separate /home partition?
Hello. I am looking to upgrade my Linux host to a different distro (Fedora 33 from Mint). Currently, my Postgres files are on my /home directory which is a separate, dedicated 2tb HDD. As I am more of a guy writing a book who needs to use a SQL database vs. an actual programmer, I am unclear about a few things!
I have managed to learn by searching online that I would normally use pg_dump as opposed to just copying my files to a flash drive and putting them back, so-to-speak after I upgrade my system. It occurred to me that maybe I do not have to do this.
If it matters, I am currently using PostgreSQL 10, Navicat 12.1.17, which I would replicate after updating. I am posting here because I cannot take anything for granted, and since it isn't as simple as just copying my files as I mentioned above, I just need to be sure I can reconnect everything after updating. I realize this is probably a very novice question, but I need to be sure before proceeding.
Please advise me if you need me to provide any further information.
I thank you in advance for any time and assistance you may be able to provide to me. It is greatly appreciated.
submitted by jcanino20
Need "Best Practice" advice to format related as 1:1 AND 1:Many
Hello. I need to know the "best practice" to handle a relationship, so that I can extract my data formatted in two different ways, without having to do things twice. I am working on a bilingual dictionary, the first of many, so I will need to do this over and over again for thousands of records.
I have been working in just one table, but realize I need to change this before things get out of hand, using a one-to-many relationship.
Using an example in Norwegian, I need to accommodate both of the following scenarios (assume a table for ONE Norwegian entry linked to a table for MANY English entries):
- One-to-many (resulting in a comma delimited field...):
Verb: å be: to ask, to invite, to request, to pray (I am assuming some kind of concatenation, although I do not have a clue how to do this across multiple records - and if that is even possible).
å be: to ask å be: to invite å be: to request å be: to pray
I need the one-to-ones to parse distinct values in both languages, and because I am pretty sure this is the "proper way" to enter my data. I need the one-to-many for printed output for two sections of the dictionary.
Assuming that I enter data one-to-one using two related tables, how can I then equate a field with ALL of the related vales to a DISCTINCT value in the main table, separated by commas? Bear in mind, being distinct will depend upon TWO fields: the main word, and the POS (part of speech - noun, verb, etc.).
I am using PostgreSQL version 10 with Navicat 12.1.17 on a Linux machine. I hope I have posed my question in a logical way as I find it a bit hard to articulate!! I consider myself to be on the starting end of being an intermediate user!
My sincere thanks for any assistance you may be able to provide.
submitted by jcanino20