On Oct 25, 2007, at 3:45 PM, Devrim GÜNDÜZ wrote:
./psql template1 -p 5433
=
[EMAIL PROTECTED]:/usr/lib/postgresql/7.4/bin$ ./psql -p 5433
template1
Welcome to psql 7.4.13, the PostgreSQL interactive terminal.
Type: \copyright for distribut
Hi,
On Thu, 2007-10-25 at 15:36 -0700, Ralph Smith wrote:
> [EMAIL PROTECTED]:/usr/lib/postgresql/7.4/bin$ ./psql -p 5433
> psql: FATAL: database "postgres" does not exist
7.4 does not have postgres database. use ./psql template1 -p 5433.
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, C
On Oct 25, 2007, at 1:57 PM, Tom Lane wrote:
Ralph Smith <[EMAIL PROTECTED]> writes:
On Oct 25, 2007, at 1:09 PM, Tom Lane wrote:
Ummm ... those are the column headings for 8.2 pg_database, not 7.4.
You're looking at the wrong postmaster.
[EMAIL PROTECTED]:/usr/lib/postgresql/7.4/bin$ ./ps
Ralph Smith <[EMAIL PROTECTED]> writes:
> On Oct 25, 2007, at 1:09 PM, Tom Lane wrote:
>> Ummm ... those are the column headings for 8.2 pg_database, not 7.4.
>> You're looking at the wrong postmaster.
> [EMAIL PROTECTED]:/usr/lib/postgresql/7.4/bin$ ./psql
> Welcome to psql 7.4.13, the PostgreSQL
On Oct 25, 2007, at 1:09 PM, Tom Lane wrote:
Ralph Smith <[EMAIL PROTECTED]> writes:
On Oct 25, 2007, at 12:24 PM, Tom Lane wrote:
Hmph. Nothing obviously wrong there, except that it's not finding
anything except template1. What does "select * from pg_database"
show?
postgres=# select * f
Ralph Smith <[EMAIL PROTECTED]> writes:
> On Oct 25, 2007, at 12:24 PM, Tom Lane wrote:
>> Hmph. Nothing obviously wrong there, except that it's not finding
>> anything except template1. What does "select * from pg_database"
>> show?
> postgres=# select * from pg_database ;
>datname | datdb
On Oct 25, 2007, at 12:24 PM, Tom Lane wrote:
Ralph Smith <[EMAIL PROTECTED]> writes:
On Oct 25, 2007, at 10:13 AM, Tom Lane wrote:
Works for me. What does the -v give you on stderr? Also,
7.4.what-exactly and 8.2.what-exactly?
Sorry for the bulk here...
Hmph. Nothing obviously wrong t
Ralph Smith <[EMAIL PROTECTED]> writes:
> On Oct 25, 2007, at 10:13 AM, Tom Lane wrote:
>> Works for me. What does the -v give you on stderr? Also,
>> 7.4.what-exactly and 8.2.what-exactly?
> Sorry for the bulk here...
Hmph. Nothing obviously wrong there, except that it's not finding
anything
==
On Oct 25, 2007, at 10:13 AM, Tom Lane wrote:
Ralph Smith <[EMAIL PROTECTED]> writes:
I want to use v8.2's pg_dumpall to export v7.4's data into a text
file.
prompt:/usr/lib/postgresql/8.2/bin$ ./pg_dumpall -c -v -p 5433 >
myfile.txt
Works for me. What does
Ralph Smith <[EMAIL PROTECTED]> writes:
> I want to use v8.2's pg_dumpall to export v7.4's data into a text file.
> prompt:/usr/lib/postgresql/8.2/bin$ ./pg_dumpall -c -v -p 5433 >
> myfile.txt
Works for me. What does the -v give you on stderr? Also,
7.4.what-exactly and 8.2.what-exactly?
I have versions 7.4 (port=5433) & 8.2 (port=5432) on this Ubuntu box.
I want to use v8.2's pg_dumpall to export v7.4's data into a text file.
(IDEALLY I'd like to port it directly to psql and avoid the file, but
I don't know if I can do that.)
Anyway, when I:
prompt:/usr/lib/postgresql/8.2/bi
11 matches
Mail list logo