The examples in this chapter can be executed in the same database we have already used, car_portal, but they do not depend on the objects in that database. To create the database, use the schema.sql script and data.sql to fill it with sample data. All the code samples are provided in the examples.sql file.
The code samples in the chapter are written based on the assumption that the user executing the commands is able to connect to a PostgreSQL server and is allowed to create databases.
The way we will define a remote server connection using the postgres_fdw extension in the section Data differences, require that the user is able to connect to the database using the host authentication type without a password. To achieve that please add two lines in the beginning of the configuration file pg_hba.conf, as follows:
host all car_portal,car_portal_new 127...