|
|
|
|
|
|
| Author |
Message |
Joseph Kiniry
*nix forums beginner
Joined: 04 Jul 2006
Posts: 2
|
 Posted: Tue Jul 04, 2006 9:28 pm Post subject:
Re: Backing up and restoring a database with the SELinux pg_user problem.
|
|
|
Hi Tom,
Thank you for the very quick response. I'll let Robin followup on
this for tonight, as I'm heading to bed after a very long day.
On 4 Jul, 2006, at 22:12, Tom Lane wrote:
| Quote: | Joseph Kiniry <kiniry@acm.org> writes:
As I said above, I have re-examined, and executed if necessary, by
hand, all sql commands in initdb and postgres.bki, but it seems that
pg_catalog is still screwed up. Attempting to dump, or perform
several other actions results in failures of the form:
ERROR: 42P01: relation "pg_user" does not exist
LOCATION: RangeVarGetRelid, namespace.c:193
STATEMENT: SELECT (SELECT usename FROM pg_user WHERE usesysid =
datdba) as dba\
, pg_encoding_to_char(encoding) as encoding, datpath FROM pg_database
WHERE dat\
name = 'gforge'
So why can I see pg_user and yet pg_dump fails?
gforge=# select * from pg_user;
[ works ]
Hmm ... you manually recreated the pg_user view you say? I wonder if
you mistakenly put it in the public schema instead of pg_catalog.
The quoted command from pg_dump is done after issuing
set search_path = pg_catalog;
so that nothing user-created will accidentally mess it up. If you
can still manually select from pg_user after issuing that same SET
command, then something is really seriously strange ...
|
I did notice the above command and executed it by hand. But as to
whether I did it all at the right time, in the right order, to ensure
that everything is in the right schemas... :)
| Quote: | If you find that indeed pg_user is in public, drop it there and
re-create it in pg_catalog. You'll need to be superuser to do
that but I don't think it'll require any more pushups than that.
|
We'll double-check this.
Thanks again for the pointer,
Joe
---
Joseph Kiniry
School of Computer Science and Informatics
UCD Dublin
http://secure.ucd.ie/
http://srg.cs.ucd.ie/
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster |
|
| Back to top |
|
 |
Jochem van Dieten
*nix forums addict
Joined: 22 Feb 2005
Posts: 61
|
| Posted: Wed Jul 05, 2006 7:23 pm Post subject:
Re: [JDBC] Is what I want possible and if so how?
|
|
|
Csaba Nagy wrote:
| Quote: | On Mon, 2006-07-03 at 17:03, Tom Lane wrote:
status and TX2's select will not return the row. This isn't entirely
perfect because LIMIT acts before FOR UPDATE: TX2's select will return
nothing, rather than selecting the next available row as you might wish.
So you might want to retry the select several times before deciding
there's nothing to do.
We do have a table like this, and in fact we did observe this behavior
that if multiple clients ask for a row at the same time, the first gets
something and the rest nothing. We're actually still looking for an
optimal solution for this...
For now, we added a random field to the table (with values 0-9), and the
clients asks with a where clause for a random value in this field. This
way there's a good chance the clients will not tip on each other's toes
(i.e. the row asked for is not locked by another client). It is still
necessary to retry a few times, but after introducing this random number
mechanism we did notice a significant performance improvement in
emptying the queue... so it must work somehow. It's true that we usually
have 10-15 clients constantly polling the queue, and the queue itself is
usually loaded with at least a few hundred tasks, so the random numbers
are reasonably distributed to be effective.
Now I wonder if there's some other way to get the same result without
additional column in the table ?
|
For a small number of processes and a large difference in time
between the 'loookup' speed and the 'work' I have used a two-step
process where you first get a batch of records and then try them
all in rapid succession. In pseudocode:
SELECT *
FROM table
WHERE condition
LIMIT number_of_queue_processes + 1;
LOOP;
BEGIN;
SELECT *
FROM table
WHERE condition AND pk = xxx
LIMIT 1 FOR UPDATE NOWAIT;
do something;
COMMIT;
END;
Jochem
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster |
|
| Back to top |
|
|
David Fetter
*nix forums Guru Wannabe
Joined: 18 Mar 2005
Posts: 113
|
| Posted: Thu Jul 06, 2006 9:24 pm Post subject:
Re: [BUGS] BUG #2517: Trouble with cx_Oracle and Plpython
|
|
|
On Thu, Jul 06, 2006 at 08:27:53AM +0000, Sergey Konoplev wrote:
| Quote: |
The following bug has been logged online:
Description: Trouble with cx_Oracle and Plpython
CREATE OR REPLACE FUNCTION "public"."function1" () RETURNS varchar AS
$body$
import cx_Oracle
connection = cx_Oracle.connect('xxx', 'xxx', 'xxx')
$body$
LANGUAGE 'plpythonu' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;
The function has executed successfully via psql interactive tool
with local transport.
pgdb:/ # /opt/PostgreSQL/bin/psql -U postgres -d transport
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
transport=# select * from function1();
function1
-----------
(1 row)
transport=#
But ORA-12154 error has been raised via same tool with remote transport.
pgdb:/ # /opt/PostgreSQL/bin/psql -U postgres -d transport -h
192.168.101.181
Password for user postgres:
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
transport=# select * from function1();
ERROR: plpython: function "function1" failed
DETAIL: cx_Oracle.DatabaseError: ORA-12154: TNS:could not resolve the
connect identifier specified
|
This means you need to fix your connect identifier for Oracle so that
it works both locally and remotely. It's a bug in your script, not in
PostgreSQL, so I'm moving this to -general :)
Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend |
|
| Back to top |
|
|
Richard Broersma Jr
*nix forums beginner
Joined: 13 Mar 2006
Posts: 44
|
| Posted: Fri Jul 07, 2006 12:59 am Post subject:
Re: Old data (was Re: Long term database archival)
|
|
|
| Quote: | -----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Richard Broersma Jr wrote:
[snip]
I am not to sure of the relevance, but I periodically worked as a
sub-contractor for an Oil-producing Company in California. They
were carrying 35 years of data on an Alpha Server running
Ca-Ingres. The really bad part is that hundreds and hundreds of
reporting tables were created on top of the functioning system
for reporting over the years. Now nobody know which tables are
relevant and with are redundant and or deprecated.
Also year after year, new custom text file reports were created
with procedural scrips. The load on the server was such that the
daily reporting was taking near taking 23 hours to complete. And
the requests for new reports was getting the IT department very
worried.
Worst of all know one there really know the ins and outs of
Ingres to do anything about it.
Well, I take part of that back. They recently upgrade to a newer
alpha to reduce the time daily reporting was taking. :-)
OpenVMS never stops, does it? :)
We've got some big OLTP systems running RDB. I dread having to move
to Oracle, even though it will be running on Linux.
|
I don't know but maybe some-one else on the list will. :-)
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster |
|
| Back to top |
|
|
Harald Armin Massa
*nix forums addict
Joined: 05 Jul 2005
Posts: 61
|
| Posted: Tue Jul 11, 2006 7:46 am Post subject:
Re: Emergency - postgre is not working
|
|
|
Hello Anika,
please see that we are in different timezones, and I usually try to sleep at
night. Please also try to keep your mail on the list, so others can try to
help you as well.
Now, dig deeper in the analyzis:
1st) Logon as Admin, checkout services.msc
is there a postgres service running? If not, why not? Any messages there?
Try to start the service from service control panel. Check out system event
log, application event log.
2nd) where is your PostgreSQL data directory? in a standard installation it
is in <program files>\postgres\8.1\data
there should be a log directory within, chechout what is in the youngest
logfiles. Maybe post it to the list.
3rd) Try to connect to postgres using psql; that is the command line
utilitie
4th) what is Postgresql used for on your computer? "sambc/core.xml" is no
application I know connected to "pgadmin". I forwarded your mail to the
postgres support list, because propably the problem is NOT connected to the
pg-admin
Additional information: the password within the .xml file is most propably
the passwort for the user within the database. NOT the postgres Service
Account password. The password of the postgres account should be irrelevant
for you, since it is only used for the service to connec.t
Best wishes,
Harald
On 7/11/06, anika evans <hianika@gmail.com> wrote:
| Quote: |
HELLO!!
I STILL NEED HELP -
I removed norton internet security and norton goback - postgre sql still
doesn't work!!!!!
I need to get this thing running - asap - before my ass is fired!!
On 7/10/06, anika evans <hianika@gmail.com> wrote:
Unfortunatly rolling back the update did not work - and adding port
5432 did not work either.
If I cant remove postgre - then what do I do??
also, When I turn on the computer I have 2 accounts on windows ex - the
Owner (administrator) account and a postgre account - the postgre acccount
requires a password - unfortunatly when I get the password from
sambc/core.xml file - the password does not work.... HELP
Thank you
Anika Evans
On 7/10/06, Harald Armin Massa <haraldarminmassa@gmail.com > wrote:
Anika,
thanks for the complete error description, I bet the culprit is in
here:
I recently updated my norton anti-virus and norton goback - and up
until then - everything for my sambc was working fine now when I try and
open sambc and I received the error message:
X 2006-07-09 22:09:19 [CORE] Connection to database failed (could not
connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?
We had many times trouble with antivirus and similiar products
interfering with the connections between pgadmin / psql and the Postrges
Server.
I recommend to NOT remove the postgres account!!
Please try to configure Norton whatever to allow connections on Port
5432. Or roll back that update.
Best wishes,
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
on different matter:
EuroPython 2006 is over. It was a GREAT conference. If you missed it,
now you can prepare budget for visiting EuroPython 2007.
|
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
on different matter:
EuroPython 2006 is over. It was a GREAT conference. If you missed it, now
you can prepare budget for visiting EuroPython 2007. |
|
| Back to top |
|
|
Harald Armin Massa
*nix forums addict
Joined: 05 Jul 2005
Posts: 61
|
| Posted: Tue Jul 11, 2006 3:14 pm Post subject:
Re: [pgadmin-support] Emergency - postgre is not working
|
|
|
Anika,
Sorry, I dont know what time zone you are in - I usually go to bed 4am and
| Quote: | am up 8am in my timezone... I do not know programming AT ALL - just
html.... I also dont know how to put the mail back on the list...sorry.
|
I am in CEST (central europe summer time) ... just giving that info, so you
do not panic if it takes time with the answer.
You can copy the mail to the list by hitting "reply all", or putting
additionally pgsql-general@postgresql.org into the "to" field-
When I run the services(local) - there is a line for
| Quote: | postgre SQL database - automatic(startup typle)automatic -(log on as)
.\userpostgres90.
|
When I check the property of the line--this is what is on path to
executable:
| Quote: |
"C:\Program Files\PostgreSQL\8.0\bin\pg_ctl.exe" runservice -N "pgsql-8.0"
-D "C:\Program Files\PostgreSQL\8.0\data\"
|
Okay, fine. You have a standard install on PostgreSQL 8.0
| Quote: | When I try and start postgre from the services.msc page - I get the
error1069 - could not start logon error.
|
Propblem gets clearer. I had similiar symptoms before; so my rough guess is:
your postgres user did loose a privilege.
Technical background:
the postgres-account is a low privileged user, which logs on automatically
when the service starts up. So he needs the privilege "log on as service"
And I think that your postgres account loosed that privilege.
So I recommend to try the following steps:
a) startup the Editor of user accounts (within control panel)
b) change the password of the postgres user account to something you know
c) restart services.msc, and open the Properties of the Postgres Services
d) go to the logon page, and enter the new password you just gave to this
account (step b)
e) try to start the service again from the service control panel
With entering the logon information again to the "logon-tab" of the service
properties dialog, you are re-giving that privilege.
Be aware that group policies within Windows Domains / Active Directory can
"take away" that privilige if not configured correctly! I do not know if you
are within Active Directory, if you are, speak to your ActiveDirectory
Adminstrator!
I use postgre to run Sam Broadcaster ..which runs 24/7 - but initally all I
| Quote: | had to do was click on my sam icon and pow it starts - now even when I click
on sam the new screen that pops up is run as..... with the choice of owner
or other????
|
That seems totally unrelated to your postgresql error!
IS IT POSSIBLE TO UNINSTALL AND REINSTALL PostgreSQL WITHOUT DAMAGING THE
| Quote: | INFORMATION ON SAMBC??? WOULD THIS FIX THE PROBLEM - SINCE IT IS A PROBLEM
THAT I HAVE NEVER ENCOUNTERED BEFORE???
|
You can uninstall and reinstall postgresql. As long as you keep your data
directory, which is standard behaviour, the information is being kept. But I
DO NOT recommend to do that! And I am quite sure it would NOT fix this
problem; which is "outside" of PostgreSQL. It would be a different matter if
the service failed with something like "pg_ctl.exe not found"; but your
PostgreSQL installation seems fine.
Tried to help you online, but you were unavailable... no idea of your time
zone, though.
Good luck with the repair, and please keep us posted,
best wishes,
Harald
On 7/11/06, Harald Armin Massa <haraldarminmassa@gmail.com> wrote:
| Quote: |
Hello Anika,
please see that we are in different timezones, and I usually try to
sleep at night. Please also try to keep your mail on the list, so others can
try to help you as well.
Now, dig deeper in the analyzis:
1st) Logon as Admin, checkout services.msc
is there a postgres service running? If not, why not? Any messages
there? Try to start the service from service control panel. Check out system
event log, application event log.
2nd) where is your PostgreSQL data directory? in a standard installation
it is in <program files>\postgres\8.1\data
there should be a log directory within, chechout what is in the youngest
logfiles. Maybe post it to the list.
3rd) Try to connect to postgres using psql; that is the command line
utilitie
4th) what is Postgresql used for on your computer? "sambc/core.xml" is
no application I know connected to "pgadmin". I forwarded your mail to the
postgres support list, because propably the problem is NOT connected to the
pg-admin
Additional information: the password within the .xml file is most
propably the passwort for the user within the database. NOT the postgres
Service Account password. The password of the postgres account should be
irrelevant for you, since it is only used for the service to connec.t
Best wishes,
Harald
On 7/11/06, anika evans <hianika@gmail.com> wrote:
HELLO!!
I STILL NEED HELP -
I removed norton internet security and norton goback - postgre sql
still doesn't work!!!!!
I need to get this thing running - asap - before my ass is fired!!
On 7/10/06, anika evans <hianika@gmail.com> wrote:
Unfortunatly rolling back the update did not work - and adding port
5432 did not work either.
If I cant remove postgre - then what do I do??
also, When I turn on the computer I have 2 accounts on windows ex -
the Owner (administrator) account and a postgre account - the postgre
acccount requires a password - unfortunatly when I get the password from
sambc/core.xml file - the password does not work.... HELP
Thank you
Anika Evans
On 7/10/06, Harald Armin Massa <haraldarminmassa@gmail.com > wrote:
Anika,
thanks for the complete error description, I bet the culprit is in
here:
I recently updated my norton anti-virus and norton goback - and
up until then - everything for my sambc was working fine now when I try and
open sambc and I received the error message:
X 2006-07-09 22:09:19 [CORE] Connection to database failed (could
not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?
We had many times trouble with antivirus and similiar products
interfering with the connections between pgadmin / psql and the Postrges
Server.
I recommend to NOT remove the postgres account!!
Please try to configure Norton whatever to allow connections on
Port 5432. Or roll back that update.
Best wishes,
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
on different matter:
EuroPython 2006 is over. It was a GREAT conference. If you missed
it, now you can prepare budget for visiting EuroPython 2007.
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
on different matter:
EuroPython 2006 is over. It was a GREAT conference. If you missed it,
now you can prepare budget for visiting EuroPython 2007.
|
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
on different matter:
EuroPython 2006 is over. It was a GREAT conference. If you missed it, now
you can prepare budget for visiting EuroPython 2007. |
|
| Back to top |
|
|
Merlin Moncure
*nix forums addict
Joined: 19 Oct 2005
Posts: 87
|
| Posted: Tue Jul 11, 2006 6:19 pm Post subject:
Re: [pgadmin-support] Emergency - postgre is not working
|
|
|
On 7/11/06, Harald Armin Massa <haraldarminmassa@gmail.com> wrote:
| Quote: | Propblem gets clearer. I had similiar symptoms before; so my rough guess is:
your postgres user did loose a privilege.
Technical background:
the postgres-account is a low privileged user, which logs on automatically
when the service starts up. So he needs the privilege "log on as service"
And I think that your postgres account loosed that privilege.
So I recommend to try the following steps:
a) startup the Editor of user accounts (within control panel)
b) change the password of the postgres user account to something you know
c) restart services.msc, and open the Properties of the Postgres Services
d) go to the logon page, and enter the new password you just gave to this
account (step b)
e) try to start the service again from the service control panel
With entering the logon information again to the "logon-tab" of the service
properties dialog, you are re-giving that privilege.
|
I'm pretty sure that simply going into properties of the service and
clicking ok will (re)grant the log on as service right.
merlin
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org |
|
| Back to top |
|
|
Paul Tilles
*nix forums beginner
Joined: 11 Jul 2006
Posts: 2
|
| Posted: Tue Jul 11, 2006 8:26 pm Post subject:
Re: doesn't recognize "!=-" (not equal to a negative value)
|
|
|
Yes. That works. I think that the parser should work properly either way.
Paul
Bruce Momjian wrote:
| Quote: | Paul Tilles wrote:
Version postgres 7.4.7:
Following sql
UPDATE tablename SET value = 0.0 where value!=-9.4;
results in the error message
ERROR: operator does not exist: smallint !=- integer
HINT: No operator matches the given name and argument type(s). You may
need to add explicit type casts.
Have you tried?
value != -9.4
---------------------------------------------------------------------------
Seems that postgres has a problem parsing a "not equal negative value".
Anybody know if this is fixed in later versions?
Paul Tilles
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
|
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings |
|
| Back to top |
|
|
Tomas Lanczos
*nix forums beginner
Joined: 22 Mar 2006
Posts: 6
|
| Posted: Thu Jul 13, 2006 8:40 pm Post subject:
re: How to insert .xls...
|
|
|
| Quote: | [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Adrian Klaver
Dates don't transfer correctly. When I try it the date moves
two days ahead.
|
I just checked it, on my computer it works fine, no date shift.
Regards
Tomas
| Quote: |
---------------------------(end of broadcast)--------------------------- |
TIP 2: Don't 'kill -9' the postmaster |
|
| Back to top |
|
|
Adam Witney
*nix forums beginner
Joined: 16 May 2005
Posts: 46
|
| Posted: Sun Jul 16, 2006 4:36 pm Post subject:
Re: I have a questions, can you help-me ?
|
|
|
vagner mendes wrote:
| Quote: | how can i do, for to install Postgresql in my Mac ? what´s steps i have do ?
Thank you by your attention.
|
(best to send these requests for help to the mailing list)
There are several options for OSX, there is an Apple article here:
http://developer.apple.com/internet/opensource/postgres.html
or use the package here:
http://www.entropy.ch/software/macosx/postgresql/
or if you are comfortable building from source, PostgreSQL compiles from
source out of the box on OSX these days... details of this are in the
source distribution.
HTH
adam
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings |
|
| Back to top |
|
|
Rhys Stewart
*nix forums beginner
Joined: 12 May 2006
Posts: 6
|
| Posted: Thu Jul 20, 2006 3:38 pm Post subject:
Re: function is quick for one row but super slow on more than 5..
|
|
|
Hi All,
the following takes about 2 seconds to run:
select route,not_in_route2(route) from ksanrt
limit 5,
but if i limit it to anything greater than 5 it takes forever to come
back. Forever as in I always cancel the query.
Any reasons why?
On 7/19/06, Rhys Stewart <rhys.stewart@gmail.com> wrote:
| Quote: | well i started by creating a table with the data i needed, instead of
working on the big table....that helped a whole lot.
thanks.
On 7/18/06, Michael Fuhr <mike@fuhr.org> wrote:
On Tue, Jul 18, 2006 at 08:11:40AM -0500, Rhys Stewart wrote:
i created a function and it takes a long time to run. I was testing it
as a wrote it and to the first drop table it takes just short of a
second. however when the rest of the code is added on, it takes
upwards of 5 minutes. Not the most appropriate thing. Are there any
tips out there for making functions go faster?
Find out what parts of the function are slow. Have you used RAISE
to display the function's progress? Have you executed any of the
queries by hand to see how fast they run? Have you used EXPLAIN
ANALYZE to see if you could benefit from rewriting a query, adding
indexes, or tuning configuration settings?
The UPDATE statement with the ORs and regular expression matches
looks like it might be slow. Is it?
--
Michael Fuhr
|
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Tue Dec 02, 2008 6:05 am | All times are GMT
|
|
Mortgage Calculator | Sony VAIO Laptop | Mortgage Calculator | Mortgage Loans | Mortgages
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
PostgreSQL
