I am trying to restore a dump from 7.4.1 to 8.0.
I am using the pg_dump in 8.0 to dump the database. I am getting the
following error message.
I looked up the pg_database table in 8.0 and there is no column named
datpath it is in 7.4.1. When I am using the pg_restore in 8.0 shouldn't
it be knowin
Hi Tom,
Yes I did a vacuum analyse right away. As a further test I restored
the exact same data on another 7.4.5 server and even without a vacuum
analyse the importer program worked as expected(fast).
I posted some more info including screen shots of the importer running
in verbose mode on
Tony Caduto <[EMAIL PROTECTED]> writes:
> I just installed 8.0 RC1 and then restored my database which was working
> perfectly on 7.4.5.
> I have a function that imports rows from a comma seperated file and on
> 7.4.5 using this same function I could get around 1000 rows every 2.5
> seconds, now
On Fri, Dec 17, 2004 at 10:28:20PM -0600, Tony Caduto wrote:
> The function in question does some selects on the table that is being
> inserted and without the indexes working it ends up taking a very long time.
>
> unfortunatly I can't supppy any of the plpgsql function code.
Can you at least p
Hi,
I just installed 8.0 RC1 and then restored my database which was working
perfectly on 7.4.5.
I have a function that imports rows from a comma seperated file and on
7.4.5 using this same function I could get around 1000 rows every 2.5
seconds, now with 8.0 RC1 this has gone way up and it seem
Scott Eade <[EMAIL PROTECTED]> writes:
> SELECT TURBINE_USER.USER_ID FROM TURBINE_USER WHERE TURBINE_USER.USER_ID = 1
> UNION
> SELECT TURBINE_USER.USER_ID FROM TURBINE_USER WHERE TURBINE_USER.USER_ID = 2
> -- The following works.
> --ORDER BY 1 ASC
> -- The following does not work when I would per
I am running PostgreSQL 8.0 Beta 4 (Windows installer) on Windows XP Pro
SP2.
The query below has three ORDER BY clauses. When I execute it with the
uncommented clause an error results. Some further commentary is
included in the comments below. I would expect the uncommented clause
to produ
[EMAIL PROTECTED] writes:
> --tablespace option doesn't work with createdb.
Works fine for me. What did you do *exactly* ?
regards, tom lane
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an i
Hi,
--tablespace option doesn't work with createdb.
(directory and files are created under $PGHOME/base )
but when I use
psql template1 <
easier if you dig into net user add, sc.exe and
ntrights.exe; you can download the last one from MS for free within
Server 2003 Ressource Kit)
- Original Message -
From: Marcio Balieiro <[EMAIL PROTECTED]>
Date: Tue, 7 Sep 2004 20:56:02 -0300
Subject: [BUGS] PostgreSQL 8.0 - very
Was the install very good, however am I needing to
do something similar in the subject of the install to create users and services
in Windows 2000/xp for an application, will it be that you could order me the
script or project that you set up for this version 8.0
beta? Question: Does
Andras Kutrovics wrote:
LOG: select() failed in statistics collector: An operation was
attempted on something that is not a socket.
What's your operating system platform?
Regards,
Andreas
---(end of broadcast)---
TIP 7: don't forget to increase your
I'm having issues installing PostgreSQL 8.0 Beta Build 20040809 on
Windows XP Home with SP2.
I'm having two different problems. First problem is when it comes time
to initialize the database with initdb. This fails and I get "Failed
to create process for initdb: 1058!" as an error message. My nex
Hello!
I downloaded and installed PostgreSQL 8.0-beta1.
After I successfully started the server, any client
connection fails to the server with the follwing
in the log file
LOG: database system was shut down at 2004-08-11 14:05:49 Central
Europe Daylight Time
14 matches
Mail list logo
