"Bethany A.Benzur" <[EMAIL PROTECTED]> writes:
> I have been running postgres for quite some time with this problem:
> whenever a user logs in or issues almost any command in the "psql"
> client, they get this error:
> -bash-2.05b$ psql
> ERROR: Relation "pg_user" does not exist
Hmmm ... I'm w
Hello,
I have been running postgres for quite some time with this problem:
whenever a user logs in or issues almost any command in the "psql"
client, they get this error:
-bash-2.05b$ psql
ERROR: Relation "pg_user" does not exist
postgres=> \l
ERROR: Relation "pg_user" does not exist
postgres=
Warren Little <[EMAIL PROTECTED]> writes:
> In an attempt to migrate from 7.3 to 7.4 doing a pg_dumpall I did not
> get any of my large objects. Is there a special process which needs to
> take place and is there a way to simple copy the large objects
> seperately?
pg_dumpall doesn't handle large
Michael Adler <[EMAIL PROTECTED]> writes:
> Is there any way to extract this (possibly intact) data?
It looks like you have one corrupted, perhaps partially zeroed, page
in your table. There may be more, but the trace output you show only
has corrupted tuples on one page (11193). You could try r
I had this problem just yesterday. I found it was due to an error a few
lines before my copy command started.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian
Sent: Wednesday, 18 February 2004 2:49 AM
To: Mike Miller
Cc: [EMAIL PROTECTED]
Subj
I recently posted a similar message but left some key info out:
I migrated my database from 7.3 to 7.4 this weekend using the pg_dumpall
tool which I now realize does not capture blobs.
I now need to move only the blob data to the 7.4 database.
The problem with redoing the dump with pg_dump -b is
CREATE RULE no_inserts_on_my_view AS ON INSERT TO
myView DO INSTEAD NOTHING;
-- Greg Patnude / The Digital
Demention2916 East Upper Hayden Lake RoadHayden Lake, ID 83835(208)
762-0762
""Dani Mezher"" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]...
Hello,
I'm in a bit of a pickle on this, so if anyone has some immediate
suggestion it would be very much appreciated
On Tue, 2004-02-17 at 10:10, Warren Little wrote:
> In an attempt to migrate from 7.3 to 7.4 doing a pg_dumpall I did not
> get any of my large objects. Is there a special process which
In an attempt to migrate from 7.3 to 7.4 doing a pg_dumpall I did not
get any of my large objects. Is there a special process which needs to
take place and is there a way to simple copy the large objects
seperately?
--
Warren Little
Senior Vice President
Secondary Marketing
Security Lending Whol
Mike Miller wrote:
> Hi,
> I'm trying to restore two dumps, one from 7.1.3 and the other from a 6.5.3
> series PgSQL server. These dumps were both made using standard 'pg_dump >
> output' commands (specifying the host where needed on one of them). When I
> run the database restore by doing e
unsubscribe
Say good-bye to spam, viruses and pop-ups with MSN Premium -- free trial offer!
The names of the participants have been changed to protect the innocent.
I'm trying to recover some lost data from this weekend. Apparently, we were able to
INSERT into critical_table without error, but not able to SELECT, COPY, or VACUUM
critical_table. I saved a copy of the PGDATA directory a
Jeremy Smith wrote:
> I looked at putty's help documentation and found a keep-alive
> setting that will send empty packets every so often to keep the
> session active. It's pretty much the same thing that happens
> when FTPing to a remote server, and this is of course the same
> recourse used to k
Recently I installed and started pg_autovacuum against my new Pg 7.4.1
installation. We use a fairly large number of temporary tables within an
application (that is, several copies of this application may be running,
and each creates and drops several temp tables as they cycle through
their wor
unsubscribe
EDMUND ZYNDA
[EMAIL PROTECTED]
FocalBase Internet Solutions
p.
410.751.2093 x219
f.
410.751.2653
www.focalbase.com
<>
15 matches
Mail list logo
