Same version of DB for dump restore? If not, was the dump done via the
pg_dump from the newer version. If not, please do that.
--
Dan Langille
http://langille.org/
On Aug 28, 2013, at 2:56 AM, Torello Querci tque...@gmail.com wrote:
Interesting .
while trying to restore
Hello folks,
PGCon 2010 will be held 20-21 May 2010, in Ottawa at the University of
Ottawa. It will be preceded by two days of tutorials on 18-19 May 2010.
We are now accepting proposals for talks.
If you are doing something interesting with PostgreSQL, please submit
a proposal. You might be
enough to
announce to the world.
Nice, how about doing the same for http://identi.ca? Support the open
source alternatives...
That was done about 22 hours ago according to this:
http://twitter.com/PGSQL_Announce/status/1281937759
--
Dan Langille
BSDCan - The Technical BSD Conference
willing to contribute their opinions when what is lacking
is heavy lifting.
--
Dan Langille - http://www.langille.org/
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your
to the Venezualan folks? SRA?
As you know, I'm strongly in favor of a good, generally respected
certification. Let's get all of the interested folks on one project.
You may know that I'm part of the BSD Certification Group. Proper
certification is not a trivial project. I joined up.
--
Dan
Hi folks,
With reference to:
http://www.postgresql.org/docs/8.2/interactive/errcodes-appendix.html
What error code would be raised for a duplicate index name?
I didn't see anything appropriate. Possibly: 42710 DUPLICATE OBJECT
thanks
--
Dan Langille - http://www.langille.org/
BSDCan
differently when you
need to play well with others.
--
Dan Langille : http://www.langille.org/
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
.
5. How often do your PostgreSQL run into problem or crash? Are most of
the problem caused by PostgreSQL itself?
I have never seen a PostgreSQL crash. Most if not all of the
problems have been caused by myself.
--
Dan Langille : http://www.langille.org/
---(end
On 14 Jul 2003 at 20:55, Ron Johnson wrote:
On Mon, 2003-07-14 at 17:44, Dan Langille wrote:
On 14 Jul 2003 at 15:16, Terence Chang wrote:
Hi all:
[snip]
Stored procedures is one reason I moved http://www.FreshPorts.org/
from MySQL to PostgreSQL.
Oh, the shame! Advertising
to be consistent with the SQL99 spec.
--
Dan Langille : http://www.langille.org/
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
in the instructions.
Downloads from: http://pgvote.unixathome.org/downloads/
Feedback can be left at: http://pgvote.unixathome.org/phorum/
Thanks
--
Dan Langille : http://www.langille.org/
---(end of broadcast)---
TIP 8: explain analyze is your friend
On 15 Jan 2001, at 8:44, J.H.M. Dassen (Ray) wrote:
On Sun, Jan 14, 2001 at 23:27:06 +1300, Dan Langille wrote:
I'm writing some stuff in PL/pgsql (actually, a lot of stuff). I have a
question: At various times, it does UPDATEs. Is there a way to tell if
the UPDATE actually affected any
the renamed tables to the new tables. Then I tried the
dump, which failed. Then I removed the renamed tables. Then the dump
worked.
Hope that helps.
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/
FreshPorts - http://freshports.org/
NZ Broadband - http://unixathome.org
13 matches
Mail list logo