2. Beyond Linux From Scratch 12.1
3. server_databases_upgradedb
4. Search

Filters

• Untranslated strings • state:empty
• Unfinished strings • state:<translated
• Translated strings • state:>=translated
• Strings marked for edit • state:needs-editing
• Strings with suggestions • has:suggestion
• Strings with variants • has:variant
• Strings with screenshots • has:screenshot
• Strings with labels • has:label
• Strings with context • has:context
• Unfinished strings without suggestions • state:<translated AND NOT has:suggestion
• Strings with comments • has:comment
• Strings with any failing checks • has:check
• Approved strings • state:approved
• Strings waiting for review • state:translated

state:>=translated

Position and priority

• Position and priority
• Position
• Priority
• Labels
• Source string
• Target string
• String age
• Last updated
• Number of words
• Number of comments
• Number of failing checks
• Key
• String location

	Translation	Source string	Target string
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Upgrade Database	Upgrade Database
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Upgrade Database	Mise à jour des bases de données
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Upgrade Database	Atualização de Base de Dados
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Important Notes About Upgrading Database Server Software	Important Notes About Upgrading Database Server Software
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Important Notes About Upgrading Database Server Software	Notes importantes sur la mise à jour du serveur de bases de données
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Important Notes About Upgrading Database Server Software	Observações Importantes Relativas a Atualização do Logiciário do Servidor de Base de Dados
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	This section is about reinstalling database software when an existing database is in use. It is not applicable for initial installations or if there is no existing database for the package being updated, but users should read through it to become aware of issues that can arise in the future.	This section is about reinstalling database software when an existing database is in use. It is not applicable for initial installations or if there is no existing database for the package being updated, but users should read through it to become aware of issues that can arise in the future.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	This section is about reinstalling database software when an existing database is in use. It is not applicable for initial installations or if there is no existing database for the package being updated, but users should read through it to become aware of issues that can arise in the future.	Cette section parle de la réinstallation des logiciels de bases de données lorsqu'une base de données est utilisée. Elle n'est pas pertinente pour l'installation initiale ou si vous n'avez pas de bases de données pour le paquet mis à jour, mais vous devriez lire cette section pour prendre connaissance des problèmes qui peuvent survenir dans le futur.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	This section is about reinstalling database software when an existing database is in use. It is not applicable for initial installations or if there is no existing database for the package being updated, but users should read through it to become aware of issues that can arise in the future.	Esta seção é sobre reinstalar logiciário de base de dados quando uma base de dados existente estiver em uso. Ela não é aplicável para instalações iniciais ou se não existir base de dados para o pacote sendo atualizado, mas os(as) usuários(as) deveriam lê-la para ficarem cientes dos problemas que podem surgir no futuro.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Let's start this chapter with a dramatic screenshot of an error that really happened. This error will not occur if you are installing database software for the first time:	Let's start this chapter with a dramatic screenshot of an error that really happened. This error will not occur if you are installing database software for the first time:
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Let's start this chapter with a dramatic screenshot of an error that really happened. This error will not occur if you are installing database software for the first time:	Commençons ce chapitre avec une copie d'écran parlante d'un problème qui a vraiment eu lieu. Ce problème n'aura pas lieu si vous installez le logiciel pour la première fois :
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Let's start this chapter with a dramatic screenshot of an error that really happened. This error will not occur if you are installing database software for the first time:	Vamos começar este capítulo com uma captura de tela dramática de um erro que realmente aconteceu. Este erro não ocorrerá se você estiver instalando o logiciário de base de dados pela primeira vez:
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	$ sudo systemctl status postgresql -- postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Tue 2021-10-26 17:11:53 CDT; 2min 49s ago Process: 17336 ExecStart=/usr/bin/pg_ctl -s -D ${PGROOT}/data start -w -t 120 (code=exited, status=1/FAILURE) CPU: 7ms Oct 26 17:11:53 SVRNAME systemd[1]: Starting PostgreSQL database server... Oct 26 17:11:53 SRVNAME postgres[17338]: 2021-10-26 17:11:53.420 CDT [17338] FATAL: database files are incompatible with server Oct 26 17:11:53 SRVNAME postgres[17338]: 2021-10-26 17:11:53.420 CDT [17338] DETAIL: The data directory was initialized by PostgreSQL version 13, which is not compatible with this version 14.0. Oct 26 17:11:53 SRVNAME postgres[17336]: pg_ctl: could not start server Oct 26 17:11:53 SRVNAME postgres[17336]: Examine the log output. Oct 26 17:11:53 SRVNAME systemd[1]: postgresql.service: Control process exited, code=exited, status=1/FAILURE Oct 26 17:11:53 SRVNAME systemd[1]: postgresql.service: Failed with result 'exit-code'. Oct 26 17:11:53 SRVNAME systemd[1]: Failed to start PostgreSQL database server.	$ sudo systemctl status postgresql -- postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Tue 2021-10-26 17:11:53 CDT; 2min 49s ago Process: 17336 ExecStart=/usr/bin/pg_ctl -s -D ${PGROOT}/data start -w -t 120 (code=exited, status=1/FAILURE) CPU: 7ms Oct 26 17:11:53 SVRNAME systemd[1]: Starting PostgreSQL database server... Oct 26 17:11:53 SRVNAME postgres[17338]: 2021-10-26 17:11:53.420 CDT [17338] FATAL: database files are incompatible with server Oct 26 17:11:53 SRVNAME postgres[17338]: 2021-10-26 17:11:53.420 CDT [17338] DETAIL: The data directory was initialized by PostgreSQL version 13, which is not compatible with this version 14.0. Oct 26 17:11:53 SRVNAME postgres[17336]: pg_ctl: could not start server Oct 26 17:11:53 SRVNAME postgres[17336]: Examine the log output. Oct 26 17:11:53 SRVNAME systemd[1]: postgresql.service: Control process exited, code=exited, status=1/FAILURE Oct 26 17:11:53 SRVNAME systemd[1]: postgresql.service: Failed with result 'exit-code'. Oct 26 17:11:53 SRVNAME systemd[1]: Failed to start PostgreSQL database server.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	$ sudo systemctl status postgresql -- postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Tue 2021-10-26 17:11:53 CDT; 2min 49s ago Process: 17336 ExecStart=/usr/bin/pg_ctl -s -D ${PGROOT}/data start -w -t 120 (code=exited, status=1/FAILURE) CPU: 7ms Oct 26 17:11:53 SVRNAME systemd[1]: Starting PostgreSQL database server... Oct 26 17:11:53 SRVNAME postgres[17338]: 2021-10-26 17:11:53.420 CDT [17338] FATAL: database files are incompatible with server Oct 26 17:11:53 SRVNAME postgres[17338]: 2021-10-26 17:11:53.420 CDT [17338] DETAIL: The data directory was initialized by PostgreSQL version 13, which is not compatible with this version 14.0. Oct 26 17:11:53 SRVNAME postgres[17336]: pg_ctl: could not start server Oct 26 17:11:53 SRVNAME postgres[17336]: Examine the log output. Oct 26 17:11:53 SRVNAME systemd[1]: postgresql.service: Control process exited, code=exited, status=1/FAILURE Oct 26 17:11:53 SRVNAME systemd[1]: postgresql.service: Failed with result 'exit-code'. Oct 26 17:11:53 SRVNAME systemd[1]: Failed to start PostgreSQL database server.	$ sudo systemctl status postgresql -- postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Tue 2021-10-26 17:11:53 CDT; 2min 49s ago Process: 17336 ExecStart=/usr/bin/pg_ctl -s -D ${PGROOT}/data start -w -t 120 (code=exited, status=1/FAILURE) CPU: 7ms Oct 26 17:11:53 SVRNAME systemd[1]: Starting PostgreSQL database server... Oct 26 17:11:53 SRVNAME postgres[17338]: 2021-10-26 17:11:53.420 CDT [17338] FATAL: database files are incompatible with server Oct 26 17:11:53 SRVNAME postgres[17338]: 2021-10-26 17:11:53.420 CDT [17338] DETAIL: The data directory was initialized by PostgreSQL version 13, which is not compatible with this version 14.0. Oct 26 17:11:53 SRVNAME postgres[17336]: pg_ctl: could not start server Oct 26 17:11:53 SRVNAME postgres[17336]: Examine the log output. Oct 26 17:11:53 SRVNAME systemd[1]: postgresql.service: Control process exited, code=exited, status=1/FAILURE Oct 26 17:11:53 SRVNAME systemd[1]: postgresql.service: Failed with result 'exit-code'. Oct 26 17:11:53 SRVNAME systemd[1]: Failed to start PostgreSQL database server.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	$ sudo systemctl status postgresql -- postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Tue 2021-10-26 17:11:53 CDT; 2min 49s ago Process: 17336 ExecStart=/usr/bin/pg_ctl -s -D ${PGROOT}/data start -w -t 120 (code=exited, status=1/FAILURE) CPU: 7ms Oct 26 17:11:53 SVRNAME systemd[1]: Starting PostgreSQL database server... Oct 26 17:11:53 SRVNAME postgres[17338]: 2021-10-26 17:11:53.420 CDT [17338] FATAL: database files are incompatible with server Oct 26 17:11:53 SRVNAME postgres[17338]: 2021-10-26 17:11:53.420 CDT [17338] DETAIL: The data directory was initialized by PostgreSQL version 13, which is not compatible with this version 14.0. Oct 26 17:11:53 SRVNAME postgres[17336]: pg_ctl: could not start server Oct 26 17:11:53 SRVNAME postgres[17336]: Examine the log output. Oct 26 17:11:53 SRVNAME systemd[1]: postgresql.service: Control process exited, code=exited, status=1/FAILURE Oct 26 17:11:53 SRVNAME systemd[1]: postgresql.service: Failed with result 'exit-code'. Oct 26 17:11:53 SRVNAME systemd[1]: Failed to start PostgreSQL database server.	$ sudo systemctl status postgresql -- postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Tue 2021-10-26 17:11:53 CDT; 2min 49s ago Process: 17336 ExecStart=/usr/bin/pg_ctl -s -D ${PGROOT}/data start -w -t 120 (code=exited, status=1/FAILURE) CPU: 7ms Oct 26 17:11:53 SVRNAME systemd[1]: Starting PostgreSQL database server... Oct 26 17:11:53 SRVNAME postgres[17338]: 2021-10-26 17:11:53.420 CDT [17338] FATAL: database files are incompatible with server Oct 26 17:11:53 SRVNAME postgres[17338]: 2021-10-26 17:11:53.420 CDT [17338] DETAIL: The data directory was initialized by PostgreSQL version 13, which is not compatible with this version 14.0. Oct 26 17:11:53 SRVNAME postgres[17336]: pg_ctl: could not start server Oct 26 17:11:53 SRVNAME postgres[17336]: Examine the log output. Oct 26 17:11:53 SRVNAME systemd[1]: postgresql.service: Control process exited, code=exited, status=1/FAILURE Oct 26 17:11:53 SRVNAME systemd[1]: postgresql.service: Failed with result 'exit-code'. Oct 26 17:11:53 SRVNAME systemd[1]: Failed to start PostgreSQL database server.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	To avoid situations like this (i.e., your database server software refuses to start), read the following discussion of the best way to upgrade a DBMS (Database Management System).	To avoid situations like this (i.e., your database server software refuses to start), read the following discussion of the best way to upgrade a DBMS (Database Management System).
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	To avoid situations like this (i.e., your database server software refuses to start), read the following discussion of the best way to upgrade a DBMS (Database Management System).	Pour éviter ce genre de situation (c.-à-d. où votre serveur de bases de données refuse de démarrer), lisez les réflexions suivantes à propos de la mise à jour d'un DBMS (système de gestion de bases de données).
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	To avoid situations like this (i.e., your database server software refuses to start), read the following discussion of the best way to upgrade a DBMS (Database Management System).	Para evitar situações como essa (ou seja, o teu logiciário do servidor de base de dados se recusa a iniciar), leia a discussão a seguir relativa a melhor maneira de atualizar um Sistema de Gerenciamento de Base de Dados (SGBD).
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	The root cause of the error shown above was an upgrade of the server software to a newer major version which left the data files untouched. In this case, the administrator was able to recover the DBMS without any loss of data.	The root cause of the error shown above was an upgrade of the server software to a newer major version which left the data files untouched. In this case, the administrator was able to recover the DBMS without any loss of data.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	The root cause of the error shown above was an upgrade of the server software to a newer major version which left the data files untouched. In this case, the administrator was able to recover the DBMS without any loss of data.	La cause principale du problème ci-dessus était la mise à jour du serveur vers une nouvelle version majeur et les fichiers de données qui n'ont pas été mis à jour. L'administrateur a réussi à corriger le problème sans perdre de données.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	The root cause of the error shown above was an upgrade of the server software to a newer major version which left the data files untouched. In this case, the administrator was able to recover the DBMS without any loss of data.	A causa raiz do erro mostrado acima foi uma atualização do logiciário do servidor para uma versão principal mais recente que deixou os arquivos de dados intactos. Nesse caso, o(a) administrador(a) conseguiu recuperar o SGBD sem qualquer perda de dados.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Even if you are doing an initial DBMS install, read through this section. It provides information about implementing backup and restore procedures (or at least a strategy for creating them) which will satisfy your needs and guarantee the safety of your data.	Even if you are doing an initial DBMS install, read through this section. It provides information about implementing backup and restore procedures (or at least a strategy for creating them) which will satisfy your needs and guarantee the safety of your data.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Even if you are doing an initial DBMS install, read through this section. It provides information about implementing backup and restore procedures (or at least a strategy for creating them) which will satisfy your needs and guarantee the safety of your data.	Même si vous effectuez une installation de DBMS initiale, lisez cette section. Elle vous donnera des informations sur la mise en place de sauvegardes et les procédures de restauration (au moins la stratégie pour les créer) suffisantes pour vos besoins et pour la sûreté de vos données.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Even if you are doing an initial DBMS install, read through this section. It provides information about implementing backup and restore procedures (or at least a strategy for creating them) which will satisfy your needs and guarantee the safety of your data.	Mesmo se você estiver fazendo uma instalação inicial do SGBD, leia esta seção. Ela fornece informações relativas a implementação de procedimentos de cópia de segurança e restauração (ou pelo menos uma estratégia para criá-las) que irão satisfazer as tuas necessidades e garantir a segurança dos teus dados.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Upgrade Database Server Packages	Upgrade Database Server Packages
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Upgrade Database Server Packages	Mise à jour des paquets de serveurs de bases de données
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Upgrade Database Server Packages	Atualização de Pacotes do Servidor de Base de Dados
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Database systems work on files which hold the database metadata and the data itself. The internal structure of these files is optimized for use by the server software. When such server software is upgraded, the new software may utilize a different file format than had previously been used. Sometimes the new software can work with the old format as well as the new one—but without the performance improvements the new format provides. Other times, the new server software will reformat the data files automatically after the upgrade.	Database systems work on files which hold the database metadata and the data itself. The internal structure of these files is optimized for use by the server software. When such server software is upgraded, the new software may utilize a different file format than had previously been used. Sometimes the new software can work with the old format as well as the new one—but without the performance improvements the new format provides. Other times, the new server software will reformat the data files automatically after the upgrade.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Database systems work on files which hold the database metadata and the data itself. The internal structure of these files is optimized for use by the server software. When such server software is upgraded, the new software may utilize a different file format than had previously been used. Sometimes the new software can work with the old format as well as the new one—but without the performance improvements the new format provides. Other times, the new server software will reformat the data files automatically after the upgrade.	Les systèmes de bases de données fonctionnent avec des fichiers qui contiennent les métadonnées de la base de données et ses données. La structure interne de ces fichiers est fortement optimisée pour être utilisée par le serveur. Lors de la mise à jour de ce serveur, le nouveau serveur peut s'attendre à un format de fichier différent qde celui utilisé précédemment. Parfois, le nouveau serveur peut utiliser l'ancien format en plus du nouveau—mais sans bénéficier du nouveau format qui peut permettre de meilleures performances. Il se peut aussi que le nouveau serveur reformate les fichiers de données automatiquement au démarrage.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Database systems work on files which hold the database metadata and the data itself. The internal structure of these files is optimized for use by the server software. When such server software is upgraded, the new software may utilize a different file format than had previously been used. Sometimes the new software can work with the old format as well as the new one—but without the performance improvements the new format provides. Other times, the new server software will reformat the data files automatically after the upgrade.	Os sistemas de base de dados funcionam em arquivos que contém os metadados da base de dados e os próprios dados. A estrutura interna desses arquivos é otimizada para uso pelo logiciário do servidor. Quando esse logiciário de servidor for atualizado, o novo logiciário poderá utilizar um formato de arquivo diferente do usado anteriormente. Às vezes, o novo logiciário pode funcionar tanto com o formato antigo quanto com o novo‐mas sem as melhorias de desempenho que o novo formato oferece. Outras vezes, o novo logiciário de servidor reformatará os arquivos de dados automaticamente após a atualização.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Unfortunately, the most likely case is that the new server software complains about out of date file formats and exits. When this happens, and you have overwritten the old server software, you may end up with a broken system and lost data.	Unfortunately, the most likely case is that the new server software complains about out of date file formats and exits. When this happens, and you have overwritten the old server software, you may end up with a broken system and lost data.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Unfortunately, the most likely case is that the new server software complains about out of date file formats and exits. When this happens, and you have overwritten the old server software, you may end up with a broken system and lost data.	Malheureusement, le cas le plus probable est que le nouveau serveur se plaigne du format obsolète et quitte. Lorsque cela se produit et que vous avez écrasé l'ancien serveur, vous pourriez vous retrouver avec un système cassé et avoir perdu vos données.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Unfortunately, the most likely case is that the new server software complains about out of date file formats and exits. When this happens, and you have overwritten the old server software, you may end up with a broken system and lost data.	Infelizmente, o caso mais provável é o de que o novo logiciário de servidor reclame dos formatos desatualizados de arquivos e saia. Quando isso acontece e você sobrescreveu o antigo logiciário do servidor, você possivelmente acabe com um sistema quebrado e perda de dados.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Changes in data file formats usually happen at major version changes, but they can also occur at other times. Before upgrading any DBMS software, check the documentation to see if this upgrade makes changes which require reformatting the database.	Changes in data file formats usually happen at major version changes, but they can also occur at other times. Before upgrading any DBMS software, check the documentation to see if this upgrade makes changes which require reformatting the database.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Changes in data file formats usually happen at major version changes, but they can also occur at other times. Before upgrading any DBMS software, check the documentation to see if this upgrade makes changes which require reformatting the database.	Les changements de format de fichiers arrivent en général au changement de versions majeures mais peuvent arriver à d'autres moments. Avant de mettre à jour un serveur de bases de données, vérifiez dans la documentation s'il y a des changements qui nécessitent le reformatage de la base de données.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Changes in data file formats usually happen at major version changes, but they can also occur at other times. Before upgrading any DBMS software, check the documentation to see if this upgrade makes changes which require reformatting the database.	As mudanças nos formatos dos arquivos de dados geralmente ocorrem em mudanças da versão principal, mas também podem ocorrer em outros momentos. Antes de atualizar qualquer logiciário de SGBD, verifique a documentação para ver se essa atualização faz mudanças que exigem reformatar a base de dados.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Of course, if you have databases with content that is not easily rebuilt, it is always a good idea to create backups of the database from time to time. Before upgrading the server software, you should run another backup.	Of course, if you have databases with content that is not easily rebuilt, it is always a good idea to create backups of the database from time to time. Before upgrading the server software, you should run another backup.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Of course, if you have databases with content that is not easily rebuilt, it is always a good idea to create backups of the database from time to time. Before upgrading the server software, you should run another backup.	Bien sur, si vous avez des bases de données dont le contenu n'est pas facile à reconstruire, c'est toujours une bonne idée de créer des sauvegardes de votre base de données de temps en temps. Vous devriez égalememt créer une nouvelle sauvegarde avant la mise à jour du serveur.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Of course, if you have databases with content that is not easily rebuilt, it is always a good idea to create backups of the database from time to time. Before upgrading the server software, you should run another backup.	Claro, se você tiver bases de dados com conteúdo que não seja reconstruível facilmente, [então] é sempre uma boa ideia criar cópias de segurança da base de dados de tempos em tempos. Antes de atualizar o logiciário do servidor, você deveria executar outra cópia de segurança.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Upgrade by Backup and Restore	Upgrade by Backup and Restore
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Upgrade by Backup and Restore	Mise à jour par sauvegarde et restauration
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Upgrade by Backup and Restore	Atualização por Cópia de Segurança e Restauração
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	A backup is useless if there is no verified process to restore the data from this backup. When running a database server, you should not only create backups; you should also verify that the restore process really works. The time to test the restore procedure is <emphasis>before</emphasis> you urgently need to recover lost data.	A backup is useless if there is no verified process to restore the data from this backup. When running a database server, you should not only create backups; you should also verify that the restore process really works. The time to test the restore procedure is <emphasis>before</emphasis> you urgently need to recover lost data.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	A backup is useless if there is no verified process to restore the data from this backup. When running a database server, you should not only create backups; you should also verify that the restore process really works. The time to test the restore procedure is <emphasis>before</emphasis> you urgently need to recover lost data.	Une sauvegarde est inutile s'il n'y a pas de processus vérifié pour restaurer les données de la sauvegarde. Lorsque vous utilisez un serveur de bases de données vous devriez non seulement créer des sauvegardes, mais vous devriez vérifier aussi que le processus de restauration fonctionne correctement. Le bon moment pour tester cette procédure est <emphasis>avant</emphasis> que vous ayez besoin de récupérer en urgence des données perdues.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	A backup is useless if there is no verified process to restore the data from this backup. When running a database server, you should not only create backups; you should also verify that the restore process really works. The time to test the restore procedure is <emphasis>before</emphasis> you urgently need to recover lost data.	Uma cópia de segurança é inútil se não existir um processo verificado para restaurar os dados a partir dessa cópia de segurança. Ao executar um servidor de base de dados, você não deveria somente criar cópias de segurança; você também deveria verificar se o processo de restauração realmente funciona. O momento de testar o procedimento de restauração é <emphasis>antes</emphasis> de você precisar recuperar urgentemente os dados perdidos.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Most database server software provides some basic tools to create backups of your data. Usually the backups created with those tools can be read by newer versions of the software (via a restore tool). Using older restore tools with newer backup data is a bad idea; you should <emphasis>never</emphasis> blindly assume that it will work. It might, but usually it doesn't.	Most database server software provides some basic tools to create backups of your data. Usually the backups created with those tools can be read by newer versions of the software (via a restore tool). Using older restore tools with newer backup data is a bad idea; you should <emphasis>never</emphasis> blindly assume that it will work. It might, but usually it doesn't.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Most database server software provides some basic tools to create backups of your data. Usually the backups created with those tools can be read by newer versions of the software (via a restore tool). Using older restore tools with newer backup data is a bad idea; you should <emphasis>never</emphasis> blindly assume that it will work. It might, but usually it doesn't.	La plupart des serveurs de bases de données fournissent des outils de base pour créer des sauvegardes de vos données. En général les sauvegardes créées avec ces outils peuvent être lues par les nouvelles versions du logiciel (avec un outil de restauration). Utiliser les anciens outils de restauration avec les nouvelles données de sauvegarde est incertain et vous ne devriez <emphasis>jamais</emphasis> supposer aveuglément que cela fonctionnera. C'est possible, mais en général ça ne marche pas.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Most database server software provides some basic tools to create backups of your data. Usually the backups created with those tools can be read by newer versions of the software (via a restore tool). Using older restore tools with newer backup data is a bad idea; you should <emphasis>never</emphasis> blindly assume that it will work. It might, but usually it doesn't.	A maioria dos logiciários de servidor de base de dados fornece algumas ferramentas básicas para criar cópias de segurança dos dados deles. Normalmente, as cópias de segurança criadas com essas ferramentas conseguem ser lidas por versões mais recentes do logiciário (por meio de uma ferramenta de restauração). Usar ferramentas mais antigas de restauração com dados de cópia de segurança mais recentes é uma má ideia; você <emphasis>nunca</emphasis> deveria assumir cegamente que isso funcionará. Pode ser, mas geralmente não.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	The easiest way to upgrade your database files is to	The easiest way to upgrade your database files is to
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	The easiest way to upgrade your database files is to	Le plus simple pour mettre à jour vos fichiers de bases de données est de
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	The easiest way to upgrade your database files is to	A maneira mais fácil de atualizar teus arquivos de base de dados é a de
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Create a full database backup using the old tools.	Create a full database backup using the old tools.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Create a full database backup using the old tools.	Créer une sauvegarde complète de votre base de données avec les anciens outils.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Create a full database backup using the old tools.	Criar uma cópia completa de segurança da base de dados usando as ferramentas antigas.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	This step creates an offline copy of the database files&mdash;for long term archiving, for disaster recovery, or as preparation for an upgrade. This offline backup consists of either (1) a full one-to-one copy of the current database files, or (2) a full backup of the database files from a certain point in time, plus all the journal data (that is Oracle&reg; terminology, it is called "Continuous Archiving" or "write ahead log (WAL)" in Postgresql) describing the changes made after that point in time. This second form takes less time to create (if the DB software provides this type of journaling) because you only have to save the data that have changed since the last full backup was created.	This step creates an offline copy of the database files&mdash;for long term archiving, for disaster recovery, or as preparation for an upgrade. This offline backup consists of either (1) a full one-to-one copy of the current database files, or (2) a full backup of the database files from a certain point in time, plus all the journal data (that is Oracle&reg; terminology, it is called "Continuous Archiving" or "write ahead log (WAL)" in Postgresql) describing the changes made after that point in time. This second form takes less time to create (if the DB software provides this type of journaling) because you only have to save the data that have changed since the last full backup was created.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	This step creates an offline copy of the database files&mdash;for long term archiving, for disaster recovery, or as preparation for an upgrade. This offline backup consists of either (1) a full one-to-one copy of the current database files, or (2) a full backup of the database files from a certain point in time, plus all the journal data (that is Oracle&reg; terminology, it is called "Continuous Archiving" or "write ahead log (WAL)" in Postgresql) describing the changes made after that point in time. This second form takes less time to create (if the DB software provides this type of journaling) because you only have to save the data that have changed since the last full backup was created.	Cette étape crée une copie hors-ligne des fichiers de bases de données pour les utiliser pour l'archivage à long terme, pour la restaurer après une catastrophe ou simplement pour préparer une mise à jour. Cette sauvegarde hors-ligne consiste (1) en une copie complète des fichiers de bases de données ou (2) d'une sauvegarde des fichiers à un certain moment de l'histoire plus toutes les données de journal (c'est la terminologie d'Oracle&reg;, ça s'appelle « Continuous Archiving » ou « write ahead log (WAL) » dans Postgresql) qui contiennent les informations sur les changements de données à partir de ce moment. Ce dernier prend moins de temps à créer si le logiciel de bases de données fournit ce type de journalisation car vous n'avez qu'à sauvegarder les dernier changements après la création de la dernière sauvegarde.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	This step creates an offline copy of the database files&mdash;for long term archiving, for disaster recovery, or as preparation for an upgrade. This offline backup consists of either (1) a full one-to-one copy of the current database files, or (2) a full backup of the database files from a certain point in time, plus all the journal data (that is Oracle&reg; terminology, it is called "Continuous Archiving" or "write ahead log (WAL)" in Postgresql) describing the changes made after that point in time. This second form takes less time to create (if the DB software provides this type of journaling) because you only have to save the data that have changed since the last full backup was created.	Essa etapa cria uma cópia fora de linha dos arquivos da base de dados&mdash;para arquivamento de longo prazo, para recuperação de desastres ou como preparação para uma atualização. Essa cópia de segurança fora de linha consiste ou em (1) uma cópia completa um-para-um dos arquivos atuais da base de dados ou (2) uma cópia completa de segurança dos arquivos da base de dados a partir de um determinado ponto no tempo, além de todos os dados do diário (ou seja, na terminologia da &quot;Oracle&reg;&quot;, é chamado de &quot;Arquivamento Contínuo&quot; ou &quot;write ahead log&quot; (&quot;WAL&quot;) no &quot;Postgresql&quot;) descrevendo as mudanças feitas depois desse ponto no tempo. Essa segunda forma leva menos tempo para ser criada (se o logiciário da Base de Dados fornecer esse tipo de registro em diário) porque você tem de salvar somente os dados que foram mudados desde quando a cópia completa de segurança mais recente foi criada.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	When upgrading database server software, a full backup (which can be used for subsequent incremental backups) should be created; but if there is a lot of data, an incremental backup will suffice. The best strategy for you depends on the amount of data stored in your database (is it a few hundred table rows, or is it hundreds of terabytes?). A full backup in the latter case can't be done quickly. To fully protect your data, create a backup of the old programs (and/or their sources) and save it, along with the data files, to be certain there is a fallback solution if the new software cannot read the old data.	When upgrading database server software, a full backup (which can be used for subsequent incremental backups) should be created; but if there is a lot of data, an incremental backup will suffice. The best strategy for you depends on the amount of data stored in your database (is it a few hundred table rows, or is it hundreds of terabytes?). A full backup in the latter case can't be done quickly. To fully protect your data, create a backup of the old programs (and/or their sources) and save it, along with the data files, to be certain there is a fallback solution if the new software cannot read the old data.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	When upgrading database server software, a full backup (which can be used for subsequent incremental backups) should be created; but if there is a lot of data, an incremental backup will suffice. The best strategy for you depends on the amount of data stored in your database (is it a few hundred table rows, or is it hundreds of terabytes?). A full backup in the latter case can't be done quickly. To fully protect your data, create a backup of the old programs (and/or their sources) and save it, along with the data files, to be certain there is a fallback solution if the new software cannot read the old data.	En terme de mise à jour du serveur, une sauvegarde complète (qui peut être utilisée pour des sauvegardes incrémentales suivantes) est recommandée, mais si la quantité de données est trop élevée, une sauvegarde incrémentale devrait être suffisante. La stratégie appropriée dépend de la quantité de données dans votre base de données (une centaine de lignes ou plusieurs centaines de téraoctets&nbsp;?). Une sauvegarde complète de cette dernière n'est pas rapide. Pour complètement protéger vos données, créez une sauvegarde des anciens binaires (et/ou leurs sources) et stockez-les avec les fichiers de données pour vous assurer qu'il y a une solution de repli si le nouveau logiciel n'est pas capable de lire les anciennes données.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	When upgrading database server software, a full backup (which can be used for subsequent incremental backups) should be created; but if there is a lot of data, an incremental backup will suffice. The best strategy for you depends on the amount of data stored in your database (is it a few hundred table rows, or is it hundreds of terabytes?). A full backup in the latter case can't be done quickly. To fully protect your data, create a backup of the old programs (and/or their sources) and save it, along with the data files, to be certain there is a fallback solution if the new software cannot read the old data.	Ao atualizar o logiciário do servidor de base de dados, uma cópia completa de segurança (que pode ser usada para cópias incrementais de segurança subsequentes) deveria ser criada; mas se existirem muitos dados, [então] uma cópia incremental de segurança será suficiente. A melhor estratégia para você depende da quantidade de dados armazenados em tua base de dados (são algumas centenas de linhas da tabela ou centenas de terabytes?). Uma cópia completa de segurança nesse último caso não pode ser feita rapidamente. Para proteger totalmente teus dados, crie uma cópia de segurança dos aplicativos antigos (e(ou) dos fontes deles) e salve-a, junto com os arquivos de dados, para ter certeza de que existe uma solução alternativa caso o novo logiciário não consiga ler os dados antigos.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Upgrade the server software	Upgrade the server software
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Upgrade the server software	Mettez à jour le serveur
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Upgrade the server software	Atualizar o logiciário do servidor
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	In this step, instructions to build the database server software are executed just as they are shown in subsequent sections talking about the DBMs like MariaDB or Postgresql. That is, build the software as usual using BLFS instructions.	In this step, instructions to build the database server software are executed just as they are shown in subsequent sections talking about the DBMs like MariaDB or Postgresql. That is, build the software as usual using BLFS instructions.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	In this step, instructions to build the database server software are executed just as they are shown in subsequent sections talking about the DBMs like MariaDB or Postgresql. That is, build the software as usual using BLFS instructions.	Pour cette étape, exécutez les instructions de construction du serveur de bases de données telles qu'elles sont montrées dans les sections suivantes parlant de DBMS comme MariaDB ou PostgreSQL. C'est-à-dire, construisez le logiciel comme d'habitude avec les instructions de BLFS.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	In this step, instructions to build the database server software are executed just as they are shown in subsequent sections talking about the DBMs like MariaDB or Postgresql. That is, build the software as usual using BLFS instructions.	Nessa etapa, as instruções para construir o logiciário do servidor de base de dados são executadas exatamente como são mostradas nas seções subsequentes falando sobre &quot;GBDs&quot; como &quot;MariaDB&quot; ou &quot;Postgresql&quot;. Ou seja, construa o logiciário normalmente usando as instruções do BLFS.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Restore the database by using the new tools.	Restore the database by using the new tools.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Restore the database by using the new tools.	Restaurez la base de données avec les nouveaux outils.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Restore the database by using the new tools.	Restaurar a base de dados usando as novas ferramentas.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	To restore the data, the tools of the newly installed server software should be used. During the restoration process, the new tools will create and/or upgrade the data files in the format the new software requires. It is assumed that newer software is capable of reading old data.	To restore the data, the tools of the newly installed server software should be used. During the restoration process, the new tools will create and/or upgrade the data files in the format the new software requires. It is assumed that newer software is capable of reading old data.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	To restore the data, the tools of the newly installed server software should be used. During the restoration process, the new tools will create and/or upgrade the data files in the format the new software requires. It is assumed that newer software is capable of reading old data.	Pour restaurer les données, vous devriez utiliser les outils du serveur nouvellement installé. Pendant la restauration, les nouveaux outils créeront ou mettront à jour les fichiers de données vers le format requis par le nouveau logiciel. On suppose que celui-ci est capable de lire les anciennes données.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	To restore the data, the tools of the newly installed server software should be used. During the restoration process, the new tools will create and/or upgrade the data files in the format the new software requires. It is assumed that newer software is capable of reading old data.	Para restaurar os dados, as ferramentas do logiciário de servidor recém-instalado deveriam ser usadas. Durante o processo de restauração, as novas ferramentas criarão e (ou) atualizarão os arquivos de dados no formato que o novo logiciário exige. Supõe-se que o logiciário mais recente seja capaz de ler os dados antigos.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Since you already have a backup procedure in place (and you have tested your restore procedure, right?), this might be the easiest way to upgrade as you can use your well known processes to upgrade just as you always do&mdash;at least in terms of the backup and restore.	Since you already have a backup procedure in place (and you have tested your restore procedure, right?), this might be the easiest way to upgrade as you can use your well known processes to upgrade just as you always do&mdash;at least in terms of the backup and restore.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Since you already have a backup procedure in place (and you have tested your restore procedure, right?), this might be the easiest way to upgrade as you can use your well known processes to upgrade just as you always do&mdash;at least in terms of the backup and restore.	Comme vous avez déjà une procédure de sauvegarde (et que vous avez testé votre procédure de restauration, n'est-ce pas&nbsp;?), c'est la manière la plus simple de mettre à jour puisque vous utilisez des procédures connues pour mettre à jour comme vous le faites toujours&mdash;au moins pour la sauvegarde et la restauration.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Since you already have a backup procedure in place (and you have tested your restore procedure, right?), this might be the easiest way to upgrade as you can use your well known processes to upgrade just as you always do&mdash;at least in terms of the backup and restore.	Como você já tem um procedimento de cópia de segurança em vigor (e testou teu procedimento de restauração, certo?), essa pode ser a maneira mais fácil de atualizar, pois você pode usar teus processos bem conhecidos para atualizar como sempre faz&mdash;pelo menos em termos de cópia de segurança e de restauração.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Upgrade the Database Files by Using System Tools	Upgrade the Database Files by Using System Tools
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Upgrade the Database Files by Using System Tools	Mise à jour des fichiers de bases de données avec des outils systèmes
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Upgrade the Database Files by Using System Tools	Atualização dos Arquivos da Base de Dados Usando Ferramentas do Sistema
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Some database systems (for instance Postgresql) provide a tool which can reformat (upgrade) the existing database files to the new format. If you need to restore from a backup (for example, running the upgrade tool failed) you will have to reinstall the old software to recover your data.	Some database systems (for instance Postgresql) provide a tool which can reformat (upgrade) the existing database files to the new format. If you need to restore from a backup (for example, running the upgrade tool failed) you will have to reinstall the old software to recover your data.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Some database systems (for instance Postgresql) provide a tool which can reformat (upgrade) the existing database files to the new format. If you need to restore from a backup (for example, running the upgrade tool failed) you will have to reinstall the old software to recover your data.	Certains systèmes de bases de données (par exemple Postgresql) fournissent un outil qui peut reformater (mettre à jour) les fichiers de bases de données existants vers le nouveau format. Si vous devez restaurer vos données à partir d'une sauvegarde (par exemple, l'outil de mise à jour ayant échoué), vous devrez réinstaller l'ancien logiciel pour retrouver vos données.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Some database systems (for instance Postgresql) provide a tool which can reformat (upgrade) the existing database files to the new format. If you need to restore from a backup (for example, running the upgrade tool failed) you will have to reinstall the old software to recover your data.	Alguns sistemas de base de dados (por exemplo, o &quot;Postgresql&quot;) fornecem uma ferramenta que pode reformatar (atualizar) os arquivos existentes de base de dados para o novo formato. Se precisar restaurar a partir de uma cópia de segurança (por exemplo, executar a ferramenta de atualização falhou), [então] você terá que reinstalar o logiciário antigo para recuperar os teus dados.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Even though the reformatting tools might work as advertised, you should create a full backup before running them. A failure could cause serious damage to the database.	Even though the reformatting tools might work as advertised, you should create a full backup before running them. A failure could cause serious damage to the database.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Even though the reformatting tools might work as advertised, you should create a full backup before running them. A failure could cause serious damage to the database.	Même si ces outils peuvent fonctionner comme attendu, vous devriez créer une sauvegarde complète avant de les lancer. Un échec peut occasionner de sérieux dommages à votre base de données.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Even though the reformatting tools might work as advertised, you should create a full backup before running them. A failure could cause serious damage to the database.	Mesmo que as ferramentas de reformatação funcionem conforme anunciado, você deveria criar uma cópia completa de segurança antes de executá-las. Uma falha poderia causar sérios danos à base de dados.
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Notes for Specific DBMS	Notes for Specific DBMS
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Notes for Specific DBMS	Remarque pour des DBMS spécifiques
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Notes for Specific DBMS	Observações para SGBDs Específicos
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	PostgreSQL	PostgreSQL
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	PostgreSQL	PostgreSQL
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	PostgreSQL	PostgreSQL
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Upstream documentation for Backup/Restore: <ulink url="https://www.postgresql.org/docs/current/backup.html"/>	Upstream documentation for Backup/Restore: <ulink url="https://www.postgresql.org/docs/current/backup.html"/>
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Upstream documentation for Backup/Restore: <ulink url="https://www.postgresql.org/docs/current/backup.html"/>	Documentation en amont pour la sauvegarde et la restauration&nbsp;: <ulink url="https://www.postgresql.org/docs/current/backup.html"/>
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Upstream documentation for Backup/Restore: <ulink url="https://www.postgresql.org/docs/current/backup.html"/>	Documentação do(a) desenvolvedor(a) para Cópia de Segurança/Restauração: <ulink url="https://www.postgresql.org/docs/current/backup.html"/>
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	MariaDB	MariaDB
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	MariaDB	MariaDB
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	MariaDB	MariaDB
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Upstream documentation for Backup/Restore: <ulink url="https://mariadb.com/kb/en/backup-and-restore-overview/"/>	Upstream documentation for Backup/Restore: <ulink url="https://mariadb.com/kb/en/backup-and-restore-overview/"/>
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — French	Upstream documentation for Backup/Restore: <ulink url="https://mariadb.com/kb/en/backup-and-restore-overview/"/>	Documentation en amont pour la sauvegarde et la restauration&nbsp;: <ulink url="https://mariadb.com/kb/en/backup-and-restore-overview/"/>
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — Portuguese (Brazil)	Upstream documentation for Backup/Restore: <ulink url="https://mariadb.com/kb/en/backup-and-restore-overview/"/>	Documentação do(a) desenvolvedor(a) para Cópia de Segurança/Restauração: <ulink url="https://mariadb.com/kb/en/backup-and-restore-overview/"/>
	Beyond Linux From Scratch 12.1/server_databases_upgradedb — English	Sqlite	Sqlite

• 1 / 2
  / 2