Messages with the subject "Help" usually don't get much response. Also,
this is not a bug report. If you have questions or need help, try the
pgsql-general or pgsql-novice mailing lists (as the bug report form
advised you to do) or ask on the EnterpriseDB forums.
Please do not reply to this me
I use this command for create TEMPORARY TABLE
now affter use this temporary i want DROP this Table but NOT WORk IF EXIST
TEMPORARY TABLE in PGsql 8.1
for this please help me
SELECT connection_log_details.connection_log_id,
textcat_all(connection_log_details.value || '|')
INTO TEMPORARY log
Jaime Casanova writes:
> On Sun, Aug 7, 2011 at 3:10 PM, John Carriel Gomez
> wrote:
>> Please help I can not replicate with Slony
>> ---
On Sun, Aug 7, 2011 at 3:10 PM, John Carriel Gomez
wrote:
> Please help I can not replicate with Slony
> -
Please help I can not replicate with Slony
-
PGRES_FATAL_ERROR select "_replicaterminal".storeNode
On Tue, Apr 19, 2011 at 4:40 AM, anij ninan wrote:
>> i install posgresql in remote server linux(centos).when i changed the
>> configuration.
>> and it has not working.could you help me please how to config pg_bha.cnf
>> in a remote server.our ip address is 67.23.238.200.
>> I would be thankful to
hi,
> i install posgresql in remote server linux(centos).when i changed the
> configuration.
> and it has not working.could you help me please how to config pg_bha.cnf
> in a remote server.our ip address is 67.23.238.200.
> I would be thankful to you if you could send me the details as early as
> p
Mohamed Fadul escreveu:
> [r...@localhost ~]# pg_restore -d esoko_local -e -1 -U postgres -v <
> /root/backupjul30
> pg_restore: invalid option -- 1
> Try "pg_restore --help" for more information.
>
You didn't inform the PostgreSQL version but I bet you're using <= 8.1.x. In
this case, that option
i did this :
[r...@localhost ~]# pg_restore -d esoko_local -e -1 -U postgres -v <
/root/backupjul30
pg_restore: invalid option -- 1
Try "pg_restore --help" for more information.
can you help me to describe what does it mean.. i did that before with the same
command
M.elnlour
Craig Ringer writes:
> sam rab wrote:
>> I tried to install postgresql 8.3.7 on Linux RedHat 7.2 platform.
>> [and got]
>> /usr/bin/ld:exports.list:1: parse error in VERSION script
> Your toolchain is just TOO OLD.
Yes. You could probably work around this particular issue by removing
the lin
sam rab wrote:
> Great day to you!
> I tried to install postgresql 8.3.7 on Linux RedHat 7.2 platform.
Maybe this is a stupid question, but ... why?
Red Hat 7.2 is *ANCIENT*. There haven't been security updates since
nigh-unto-forever. It's using C libraries with a completely different
threa
Great day to you!
I tried to install postgresql 8.3.7 on Linux RedHat 7.2 platform.
Process of "configure" ends normally,
process of "gmake" ends with this output of errors:
{
gmake[3]: Entering directory
`/usr/home/install/postgresql-8.3.7/src/interfaces/
libpq'
gcc -O2 -Wall -Wmis
Hello,
We work in an institution for teaching and research and
we have a medium database using PostgreSQL, with around 290GB, where
most of the data refers to binary files (blobs).
Initially, I wonder if we can exchange information about the database
with respect to postgresql missmatches OIDs wh
how to dump it ???
pg_dump is not working :
pg_dump: query to obtain list of schemas failed: ERROR: more than one
row returned by a subquery used as an expression
Tom Lane пишет:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
[EMAIL PROTECTED] wrote:
I don't know how, but i got 2 postgr
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] wrote:
>> I don't know how, but i got 2 postgres users.
> You've got transaction wraparound problems. Start here:
Vacuuming isn't gonna help though. The tuple at (0,2) has been frozen,
which means that vacuum has certainly been run
[EMAIL PROTECTED] wrote:
> Hello, help me please,
> I don't know how, but i got 2 postgres users.
> How can I delete the first one
> thx alot for your answers.
You've got transaction wraparound problems. Start here:
http://search.postgresql.org/search?q=transaction+wraparound&m=1&l=&d=365&s
Hello, help me please,
I don't know how, but i got 2 postgres users.
How can I delete the first one
thx alot for your answers.
Oleg
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Hello, help me please,
I don't know how, but i got 2 postgres users.
How can I delete the first one
thx alot for your answers.
///
select passwd,ctid,xmi
Respected sir,
I am new Postgres Sql and I am using this database with Java Technology.
I am executing the below statements in command prompt and they are executing
fine but when I am executing it through my java program it is also working
fine but it is not coming. It is continuously execu
[EMAIL PROTECTED] wrote:
Hello?
help me plz? i don't khow what to do...
How can I delete first postgres user.
template1=# select usename,passwd,valuntil,ctid,xmin,xmax,cmin,cmax
from pg_shadow where usesysid=1;
usename | passwd| valuntil | ctid |
xmin | xmax
[EMAIL PROTECTED] wrote:
How can I delete first postgres user.
Ugh. How did you duplicate if there is an unique index in rolname ?
pg_shadow is a view; you want to take a look at the real relation
pg_authid.
delete from pg_authid where ctid = '(0,1)'
--
Euler Taveira de Oliveira
http
Hello?
help me plz? i don't khow what to do...
How can I delete first postgres user.
template1=# select usename,passwd,valuntil,ctid,xmin,xmax,cmin,cmax from
pg_shadow where usesysid=1;
usename | passwd| valuntil | ctid | xmin
| xmax | cmin | cmax
--
"Josh Tolley" <[EMAIL PROTECTED]> writes:
> pg_shadow is a view based on pg_authid.
Not in 7.4 it wasn't ...
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> I have two "postgres" user. How to delete the first one ???
Let's see the system columns (ctid,xmin,xmax,cmin,cmax) for those
two rows?
regards, tom lane
---(end of broadcast)---
On Dec 28, 2007 7:01 AM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> hello
>
> Help me please...
> I have two "postgres" user. How to delete the first one ???
>
> ***
> # select * from pg_shadow where usesysid=1;
> usename | usesysid | usecreatedb | usesuper | usecatupd
> |
hello
Help me please...
I have two "postgres" user. How to delete the first one ???
***
# select * from pg_shadow where usesysid=1;
usename | usesysid | usecreatedb | usesuper | usecatupd
| passwd| valuntil | useconfig
--+--+--
I have a service that was installed on my pc with the postgres service.
We went in and had to change the password to match our domain policies
and now ever time we reboot it re-writes the password to something else
on the service and we have to change it under logon as,
Any thoughts?
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> And i don't know why but there are dumplicate schemas:
Duplicate pg_shadow rows for user postgres, most likely. When did
you last vacuum pg_shadow?
regards, tom lane
---(end of broadcast)--
Hello.
Can you help me? i don't know what to do with this message:
**
# pg_dump -U postgres catalog
Password:
pg_dump: query to obtain list of schemas failed: ERROR: more than one
row returned by a subq
On 9/8/07, LIZETH ANGHELA SIRPA CACERES <[EMAIL PROTECTED]> wrote:
> Escribo para comunicarle que estoy realizando mi tesis.
>
> soy egresada de la carrera de Informatica de la Universidad Mayor de San
> Andres de LA PAZ-BOLIVIA, me encuentro realizando mi tesis, estoy trabajando
> en una idea para
Escribo para comunicarle que estoy realizando mi tesis.
soy egresada de la carrera de Informatica de la Universidad Mayor de San
Andres de LA PAZ-BOLIVIA, me encuentro realizando mi tesis, estoy trabajando
en una idea para complementar la seguridad en Postgres, y me entere que
usedes trabajan con
Siraj Khan wrote:
Dear Team,
I am working for small firm in Mumbai, India. We are interested in
running Postgres 8.2 database on IBM unix platform (Power5 processor).
Need your help in confirmation whether Postgres 8.2 runs on
* AIX 5.3 OS on Power5 cpu
this is a platform that is both
Dear Team,
I am working for small firm in Mumbai, India. We are interested in running
Postgres 8.2 database on IBM unix platform (Power5 processor). Need your help
in confirmation whether Postgres 8.2 runs on
AIX 5.3 OS on Power5 cpu
SLES 9 OS on Power5 platform
Please help
On 26 Sep 2006 07:21:53 -0700, Mussum <[EMAIL PROTECTED]> wrote:
I am developing an application and I am not obtaining to leave this
error:
org.postgresql.util.PSQLException: Não está inserindo um registro.
org.postgresql.jdbc2.AbstractJdbc2ResultSet.insertRow(AbstractJdbc2ResultSet.java
I am developing an application and I am not obtaining to leave this
error:
org.postgresql.util.PSQLException: Não está inserindo um registro.
org.postgresql.jdbc2.AbstractJdbc2ResultSet.insertRow(AbstractJdbc2ResultSet.java:618)
com.sun.rowset.JdbcRowSetImpl.insertRow(JdbcRowSetImp
Vaccaro wrote:
I never download your product i don't even know what it is. When i
started my computer up i saw 2 new accounts created. User Accounts.
The accounts names were postgres services. It was password protected
and limited account. I am running on windows XP. I Did delete the
account
Someone discovered our diabolical plot to secretly install postgres on
every computer across the globe! Quickly! Dispatch the Deadly Viper
Assassination Squad to silence him!
Vaccaro wrote:
I never download your product i don't even know what it is. When i
started my computer up i saw 2 new a
I never download your product i don't even know
what it is. When i started my computer up i saw 2 new accounts created. User
Accounts. The accounts names were postgres services. It was password
protected and limited account. I am running on windows XP. I Did delete the
accounts. I want to k
Stephan Szabo wrote:
On Mon, 22 Aug 2005, Paul Bramble wrote:
Is there an easy way to get started so I can quickly install Postgress and
load my schema?
You didn't say what kind of system you're running, but getting a packaged
version of PostgreSQL (RPM, DEB, Windows Installer) will probabl
On Mon, 22 Aug 2005, Paul Bramble wrote:
> Is there an easy way to get started so I can quickly install Postgress and
> load my schema?
You didn't say what kind of system you're running, but getting a packaged
version of PostgreSQL (RPM, DEB, Windows Installer) will probably help on
the install
I am working on a product that uses a database for some elementary
permanent storage. Currently we are using Firebird.
I have been asked to evaluate the product against Postgres,
but I have limited time to do so.
Is there an easy way to get started so I can quickly install
Postgres
Mahesh Shinde wrote:
Hi I have created an Application in VB . In this application I want
to show records in the grid using a like query which fetch the values
from the table which is having about 55 lac debtor list in it. I have
applied like query on Debtor Id which is a primary key and having
in
Hi
I have created an Application in VB . In this
application I want to show records in the grid using a like query which fetch
the values from the table which is having about 55 lac debtor list in
it. I have applied like query on Debtor Id which is a primary key and having
index on it.
I
dear sir or madam,
i have trouble with my databases how to load my db become a graphic i use pgaccess to user interface please help me
Yahoo! Messenger - Communicate instantly..."Ping" your friends
today! Download Messenger Now
Hi,
I have installed
PostgreSQL 8.0.1 on Solaris 9.
I am porting my
database from Oracle 9i to PostgreSQL. I am using PL/pgSQL
language.
In Oracle we can
get error message from "SQLERRM" keyword and inserting it into table.
How can I get
error message/code in PostgreSQL after an E
I have a problem in my postgres production
db.
Today pg_dump is failed with the error :
MemoryContextAlloc .
I find the row that caused the problem making same
query "SELECT * FROM TABLE LIMIT n" .
The row in fact seemed have a varchar very
strange.
But few minutes later I have done a select
I downloaded the new postgress, Installed it and did as you commanded at the
cmd prompt;
postmaster -U postgres -i
and got this message:
(Execution of Postgres SQL by a user with administrative permissions is not
permitted.
The server must be started under an unprivleged user ID to prevent possi
Hi!
I’m still with the problem in installation of
postgre; "failed to create process for initdb". I create two users
with a greate permission in Windows2003.
Can you help me, like a screen with the users creates
or other thing?
So, tanks.
Estevan Rech
Software Developer
Please help I am trying to install PostgreSQL using cygwin
on WindowsXP and I am getting this error:
$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/test/
The files belonging to this database system will be owned by
user "JRademan".
This user must also own the server process.
Th
Tom,
I got a reply back from someone on the apple
developers list.
> gcc -traditional-cpp -g -O2 -Wall
-Wmissing-prototypes
^^^
This is wrong. You need to use -no-cpp-precomp. It
says this in the release notes for the December tools
updater, as well as a number of other thin
Find it
gcc 3.3 dont support space character (0x20) before #ifdef
try this :
test.c
#include
int main()
{
return 0;
}
gcc -traditional-cpp -g -O2 -Wall -Wmissing-prototypes
-Wmissing-declarations -c -o
test.o test.c
you have the same errors ...
but this works
gcc -traditional-cpp -g -O
Hi Theodore
I download 7.3.4 and build it !!!
All of PostgreSQL successfully made. Ready to install.
i am in OS X.2.6 and
% gnumake -v
GNU Make version 3.79, by Richard Stallman and Roland McGrath.
Built for powerpc-apple-darwin6.0
Copyright (C) 1988, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99
Theodore Petrosky <[EMAIL PROTECTED]> writes:
> any ideas... i believe the problem lies with the
> december 2002 update to the developers tools.
There is some recent traffic in our archives suggesting that Apple's
gcc 3.3 is busted. I have not been able to check this out because
my Powerbook is i
Please help with a mac osx installation... I had
installed 7.3.4 on osx 10.2.6 some months ago. it was
a painless installation. I responded to someone on the
apple help list about installing. this person was
having a problem with the make stage. I didn't think
to retry making on my system.
I did.
Dear All,
With regard to the rather old bug report about pg_dump outputting ACL
commands on views before the views have been created (see
http://archives.postgresql.org/pgsql-general/2001-07/msg01051.php), I
take it this bug is fixed in the latest release?
More importantly, is there anywhere I ca
Hi,
Everything my server output this message error:
DEBUG: query: update gn_anuncio set
qtdclk=qtdclk +1 where codanu=196789DEBUG:
CommitTransactionCommand/iG/dbms/postgres/bin/postmaster: BackendStartup:
pid 1136 user producao db producao socket 5FindExec: found
"/iG/dbms/postgres/bin
bash$ /usr/local/pgsql/bin/pg_dumpall > db.out
ERROR: MemoryContextAlloc:
invalid request size 4294967293
PQendcopy: resetting connection
SQL query to dump the contents of Table 't_oommain' did not execute
correctly. After we read all the
table contents from the backend, PQendcopy() failed
Dear Support,
I was unsuccessfull with the OpenNMS deployment. I believe it might have
something to with the RedHat psyche 8.0 version incompatibility or something
else I am going to unstall all the rpm's and see if that makes a
difference. I have attached the discovery.log file that has error
dear michael£º
my postgres is version 7.2.3,and i want to use "show all"=3D
function,would you please
send me a copy of C code of "show all " function which can run=3D
on 7.2.3.
I'm in grest need of it.Many thanks to you!!
ÖÂ
Àñ£¡
¡
Then again, dumping is probably better, and deleting the database, and
then restoring it.
I am just curious if it is a database problem or a table problem.
If you can creat new tables that work fine, but it is a strange issue.
Mark
>
> I would create new tables, copy the data over, then dro
I would create new tables, copy the data over, then drop the old tables,
and rename the new tables.
I have had similar problems iwht MySQL, but never with PostgreSQL.
Mark
>
> Hi,
>
> I have been using PostgreSQL 7.2.2 for a while now on one of our live
> machines, however all of a sudden w
"Brendon Matthews" <[EMAIL PROTECTED]> writes:
> I have been using PostgreSQL 7.2.2 for a while now on one of our live
> machines, however all of a sudden with no warning, we are no longer able to
> run any UPDATE statements on one of our databases. SELECT and INSERT
> statements have no issues.
>
On Thu, 2002-09-12 at 01:13, Brendon Matthews wrote:
> Hi,
>
> I have been using PostgreSQL 7.2.2 for a while now on one of our live
> machines, however all of a sudden with no warning, we are no longer able to
> run any UPDATE statements on one of our databases. SELECT and INSERT
> statements ha
Hi,
I have been using PostgreSQL 7.2.2 for a while now on one of our live
machines, however all of a sudden with no warning, we are no longer able to
run any UPDATE statements on one of our databases. SELECT and INSERT
statements have no issues.
The error we are getting is:
"The backend has brok
Hi,
i am new to linux. so I want to install postgress in windows.
please please tell me the steps/ procedure to install postgress in
windows 2000. i have downloaded cygwin, tcl84b1.. in search of an
way to install postgress in windows.
I work mostly on php / mysql and theres no prob with worki
Well, you had to create that user, not postgresql! Log in as root and type:
passwd postgres
you can set the password to whatever you like.
Tim
- Original Message -
From: "martin tan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 1:05 A
On Tue, 23 Apr 2002 03:05-0500, martin tan wrote:
> I would just want to ask if what is the default password of
> postgresql after installing it... coz when i type su postgres it
> ask me a password which i dont know what?
Have you assigned a password at all to your postgres user?
This is done u
I would just want to ask if what is the default password of postgresql after
installing it... coz when i type su postgres it ask me a password which i dont know
what?
Thnx
--
___
Sign-up for your own FREE Personalized E
Tom Lane writes:
> Seems to me it makes more sense to check $PGDATA, not one individual
> file within the directory. Ultimately we depend on $PGDATA to have
> the right permissions.
Check moved.
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane writes:
>> This is probably overly restrictive; in fact, I would argue that there
>> should be no such check at all. We do not do runtime checks for
>> permissions on any other files, and some of them are far more sensitive
>> than postgresq
Tom Lane writes:
> A look at the source code shows it wants 744 or less.
>
> This is probably overly restrictive; in fact, I would argue that there
> should be no such check at all. We do not do runtime checks for
> permissions on any other files, and some of them are far more sensitive
> than p
> bonolin <[EMAIL PROTECTED]> writes:
> > I install postgres 7.1 on solaris 2.6(sparc cpu).And create some
> > db,runing normal.Today,I want to restart the database,it report
> > "FATAL 1: configuration file `postgresql.conf' has wrong
> > permissions",I check and change the permission to
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Isn't the file in /data, which is 700. Why do we care what permissions
> we give it?
Indeed. I could understand having a postmaster-start-time check that
$PGDATA has mode 700 (initdb makes this true anyway, but having the
postmaster double-check is no
bonolin <[EMAIL PROTECTED]> writes:
> I install postgres 7.1 on solaris 2.6(sparc cpu).And create some
> db,runing normal.Today,I want to restart the database,it report
> "FATAL 1: configuration file `postgresql.conf' has wrong
> permissions",I check and change the permission to 775 ,but f
pgsql-bugs:
Hello!
I install postgres 7.1 on solaris 2.6(sparc cpu).And create some db,runing
normal.Today,I want to restart the database,it report "FATAL 1: configuration file
`postgresql.conf' has wrong permissions",I check and change the permission to 775 ,but
fail either,can you help.
Title: help - Installing
Hi,
I need help with finding some Documentation about how to install PostGerSQL on windows 2000
Step by step since I am trying to install PostGerSQL DB on Win2000 O/S.
I have install the Cygwin but when I try create a database I get:
$ createdb iweb
psq
On Thu, 31 May 2001, Letitia Hickman wrote:
> Getting a "Warning: PostgreSQL query failed: ERROR: Cannot insert a
> duplicate key into unique index
> auditlog_pkey in /htdocs/ecorp-real-estate.com/intranet on line 167"
>
> Continue to get also
>
> :Warning: PostgreSQL query failed: ERROR: pars
Getting a "Warning: PostgreSQL query failed: ERROR: Cannot insert a
duplicate key into unique index
auditlog_pkey in /htdocs/ecorp-real-estate.com/intranet on line 167"
Continue to get also
:Warning: PostgreSQL query failed: ERROR: parser: parse error at or near
"," in /htdocs/ecorp-real-estate
Vinicio Llumiquinga <[EMAIL PROTECTED]> writes:
> fmgr_info: function 18816: cache lookup failed
> This happend when I write any function.
I suspect you dropped the plpgsql call handler function.
If so, the only convenient recovery method AFAIK is to drop the
plpgsql language entry and all your
I have a problem
I have a function in plpgsql:
create function add_one (integer) returns integer as '
begin
return $1+1;
end;
' language 'plpgsql';
When I create in psql monitor this function the message is CREATED
Then I write:
select add_one(1);
and always say:
fmgr_info: function 18816:
POSTGRESQL BUG REPORT TEMPLATE
Your name : Thomas Waelde
Your email address : [EMAIL PROTECT
i have a problems for deploying database POSTGRESQL ON MY OS linux
first point is :
i want to put the data of database in another location, what can i do at
installation and after installation
second point is:
when the location is full what can i do for extend the database in the nex
location
82 matches
Mail list logo
