Re: [HACKERS] dump + restore didn't include schemas

2004-01-31 Thread Tom Lane
"Dan Langille" <[EMAIL PROTECTED]> writes: > On 31 Jan 2004 at 11:56, Tom Lane wrote: >> 7.4's pg_dump will use AUTHORIZATION so that situations like this >> restore correctly, but 7.3's pg_dump is stupid and tries to create the >> schema as its owner. > Does it matter that I used pg_dumpall? No.

Re: [HACKERS] dump + restore didn't include schemas

2004-01-31 Thread Dan Langille
On 31 Jan 2004 at 11:56, Tom Lane wrote: > "Dan Langille" <[EMAIL PROTECTED]> writes: > >>> I upgraded two servers today from 7.3.* to 7.4.1. In both cases, the > >>> schemas which existed in the original databases were not created in > >>> the new database. > > > I found three of these messag

Re: [HACKERS] dump + restore didn't include schemas

2004-01-31 Thread Tom Lane
"Dan Langille" <[EMAIL PROTECTED]> writes: >>> I upgraded two servers today from 7.3.* to 7.4.1. In both cases, the >>> schemas which existed in the original databases were not created in >>> the new database. > I found three of these messages in /var/log/messages on the box which > had the pr

Re: [HACKERS] dump + restore didn't include schemas

2004-01-31 Thread Dan Langille
On 30 Jan 2004 at 23:34, Tom Lane wrote: > "Dan Langille" <[EMAIL PROTECTED]> writes: > > I upgraded two servers today from 7.3.* to 7.4.1. In both cases, the > > schemas which existed in the original databases were not created in > > the new database. > > New issue? Known bug? > > New one on

Re: [HACKERS] dump + restore didn't include schemas

2004-01-30 Thread Tom Lane
"Dan Langille" <[EMAIL PROTECTED]> writes: > I upgraded two servers today from 7.3.* to 7.4.1. In both cases, the > schemas which existed in the original databases were not created in > the new database. > New issue? Known bug? New one on me. Look at the log output from when the dump was bein

[HACKERS] dump + restore didn't include schemas

2004-01-30 Thread Dan Langille
Hi folks, I upgraded two servers today from 7.3.* to 7.4.1. In both cases, the schemas which existed in the original databases were not created in the new database. The CREATE SCHEMA commands are there... \connect "freebsddiary.org" -- -- PostgreSQL database dump -- SET SESSION AUTHORIZATION