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
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
> -
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
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
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
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
[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
"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
> |
"[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)--
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
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
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
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
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
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
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
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
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
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 AM
Subject: [BUGS] help!
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
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
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
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
43 matches
Mail list logo
