Re: [SQL] pg_dump/pg_restore question

[Richard Huxton]

Worik wrote:
Freinds
I am new to this list, and this is my first message.
I hope this is the correct forum, and the question not too stupid/simple.
I have a database on a debian stable system...
dpkg -l postgresql
[snip]
ii  postgresql 7.2.1-2woody5  Object-relational SQL database, 
descended fr

When I dump a database (as from the man page for pg_restore)
pg_dump mydb > mydb.out
OK.  Get an SQL dump in mydb.out
Create a new database
creatdb myotherdb
Load the dump
psql -d myotherdb -f mydb.out
psql:mydb.out:4: \connect: FATAL 1:  IDENT authentication failed for 
user "postgres"

I have tried adding the line
host   all 127.0.0.1 255.255.255.255trust
to pg_hba.conf but it makes no difference.
Almost correct. You're not actually connecting over IP at all, you'll be 
using unix-sockets. Try a line something like:
  local  all  all  trust
Or, since you're on 7.2 probably
  local  all  trust

HTH
--
  Richard Huxton
  Archonet Ltd
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[SQL] array_in: '{}}'::text[]

[Markus Bertheau]

Is there a reason the array_in parser accepts additional closing braces
at the end?

oocms=# SELECT '{}}'::text[];
 text
--
 {}
(1 ÑÑ)

Thanks

-- 
Markus Bertheau <[EMAIL PROTECTED]>


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org

Re: [SQL] array_in: '{}}'::text[]

[Markus Bertheau]

Ð ÐÐÐ, 23.08.2004, Ð 13:45, Markus Bertheau ÐÐÑÐÑ:
> Is there a reason the array_in parser accepts additional closing braces
> at the end?

In fact it seems to accept everything after the closing brace matching
the first opening brace.

Thanks

-- 
Markus Bertheau <[EMAIL PROTECTED]>


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] disable constrained (contd.)

[Markus Bertheau]

Ð ÐÑÐ, 22.08.2004, Ð 02:41, Roman Kunert ÐÐÑÐÑ:

> I am also looking for an easy way to disable foreign key constraint 
> check while importing data from one database to PostgreSQL. The one 
> suggested method (see link above) that modifies pg_catalog.pg_class is 
> not preferrable, as it requires super user rights, the other one that 
> works by dropping the foreign key, doing the inserts and then adding it 
> back again does not seem to work, as it results in an constraint check 
> error when I execute the ADD statement (it complains about the reference 
> to a row in another table that has not been imported yet, but will be 
> later during the import)

Add the constraint when you're done importing all data.

-- 
Markus Bertheau <[EMAIL PROTECTED]>


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] sleep function

[John DeSoi]

Hi Greg,
On Aug 22, 2004, at 11:52 PM, Greg Stark wrote:
test=# create or replace function sleep(integer) returns integer as 
'return sleep(shift)' language plperlu;
CREATE FUNCTION

The original request was for something in built-in to PostgreSQL. I 
have not used plperl (or any of the other pl languages), but I assume 
there will be additional installation and configuration issues to use 
them. But thanks for the example, it will be helpful if I need 
something more processor friendly.

Best,
John DeSoi, Ph.D.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[SQL] TSearch2 other languages

[Cavit Keskin]

We are working on 9 separate databases for 9 different
languages: Turkish, English, Spanish, Russian, Arabic, Danish, German, Japanese
and Albanian.

tsearch2 (fult-text search) is the one for internal search engine
but only English and Russian for tsearch2 are supported in Postgresql sources.

If you have tsearch support for the other languages we will
greatly appreciate your help.

Thank you.

Re: [SQL] array_in: '{}}'::text[]

[Joe Conway]

Markus Bertheau wrote:
Is there a reason the array_in parser accepts additional closing braces
at the end?
oocms=# SELECT '{}}'::text[];
 text
--
 {}
(1 ÑÑ)
Hmmm, I was *about* to say that this is fixed in cvs (and indeed, the 
array_in parser is significantly tightened up compared to previous 
releases), but unfortunately, there is still work to be done :(

regression=# SELECT '{}}'::text[];
 text
--
 {}
(1 row)
regression=# select version();
   version
-
 PostgreSQL 8.0.0beta1 on x86_64-unknown-linux-gnu, compiled by GCC gcc 
(GCC) 3.3.3 20040412 (Red Hat Linux 3.3.3-7)
(1 row)

Look for a fix soon, at a cvs repository near you
Joe
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faqs/FAQ.html

Re: [SQL] reply to setting

[Joe Conway]

Greg Stark wrote:
Just as a side comment, one trick I found very helpful in my mail filters is
to treat any message with one of my message-ids in the references as a
personal message as far as mail notifications. This way I get notifications
for any message on a thread following a post of my own.
Interesting idea -- thanks!
Joe
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

Re: [SQL] TSearch2 other languages

[Josh Berkus]

Cavit,

> If you have tsearch support for the other languages we will greatly
> appreciate your help.

I'm pretty sure that you'll need to implement the other languages yourself.  
The OpenFTS project (openfts.sourceforge.net) has some documentation on how 
to do so.

The community will really appreciate it if you can do so; it's time we 
expanded the number of TSearch languages and efforts like yours are how it 
happens.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [SQL] surrogate key or not?

[sad]

On Sunday 08 August 2004 04:29, Kenneth Gonsalves wrote:

> but why would anyone want to change the value of an autogenerated serial
> row?


because of catenating data from two or more databases.


---(end of broadcast)---
TIP 8: explain analyze is your friend