API design decision: Naming

[JelteF]

Do we want:

CREATE EXTENSION pgbouncer;

or

CREATE EXTENSION pg_pgbouncer;

What about GUCs and the schema. Should they be pgbouncer.some_table or pg_pgbouncer.sometable.

Changing the extension name completely to something else, would also be acceptable to me.

[petere]

Let's use pg_pgbouncer consistently as the extension name and namespace for this. Otherwise it would be confusing.