Your name : KIRILL
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) : AMD Athlon
Operating System (example: Linux 2.0.26 ELF) : Windows 2000
PostgreSQL version (example: Postg
Hello
I have installed PostgreSQL on Red Hat 9 . I have a problem: I have
added new user of the database system , the name of this user is :
"jan" . I have given him
the permission for creating new databases and for adding new users,
but when I
wrote:
psql -U jan template1
then I have
Hello Sir,
I am trying to install Postgresql-7.2 on Windows 2000.
As per requirement I have downloaded the Cygwin and Cygipc
packages.
I have also been successful in starting ipc-daemon
service.
But when I am giving './configure'
I am geting following message
"loading cache ./co
Hi!!
I am trying to install Postgresql-7.2 on Windows 2000.
As per requirement I have downloaded the Cygwin and Cygipc packages.
I have also been succesful in starting ipc-daemon service.
But when I am giving './configure'
I am geting following message
"loading cache ./config.cache
checking ho
I sent a message to the email address that I was told to use to
unsubscribe and was told I would get an email back with directions and i
never did and I am still getting these emails.
Will someone please go in manualy and remove me?
Thank you!
---(end of broadcast)---
Hi ALL
i have problem after backup
i have three database on one server. when i backup is done complete.
but after backup my pc's speed is very slow. it is requery to restart PC.
please give some ans.
Ramesh Patel
---(end of broadcast)---
TIP 6: H
On Tue, 2004-04-06 at 11:06, Lukasz wrote:
> Hello
>
> I have installed PostgreSQL on Red Hat 9 . I have a problem: I have
> added new user of the database system , the name of this user is :
> "jan" . I have given him
> the permission for creating new databases and for adding new users,
> but
On Tue, 12 Feb 2002, Raghav wrote:
> Hi!!
> I am trying to install Postgresql-7.2 on Windows 2000.
> As per requirement I have downloaded the Cygwin and Cygipc packages.
> I have also been succesful in starting ipc-daemon service.
> But when I am giving './configure'
>
> I am geting following m
Raghav wrote:
>
> Hi!!
> I am trying to install Postgresql-7.2 on Windows 2000.
> As per requirement I have downloaded the Cygwin and Cygipc packages.
> I have also been succesful in starting ipc-daemon service.
> But when I am giving './configure'
>
> I am geting following message
>
> "loadi
Hi,
I'm at my wits end with this one.
I'm using PostgreSQL 7.1.3 on Solaris 2.8.
I want to create two databases in the same
postmaster. I did my initdb and started
the postmaster. I set two environment
variables, one for each database's location.
Next:
initlocation -D DB1
initlocation -D DB
PostgreSQL version 8.1.4
Linux version 2.6.19-gentoo-r5 (gcc version 4.1.1 (Gentoo 4.1.1))
I make backup with commang:
pg_dump -U postgres -h /tmp -Ft -b -C mydb > file.tar
When I want to restore from backup, i give error.
pg_restore -U postgres -d template1 -v -C < file.tar
error report:
Hi,
We have our application which uses postgres 7.1.3 version in
that we use a time functions like now(),timestamp. etc mostly
timestamp without timezone.We don't need the timezone in that variable
so we ignore it using timestamp without timezone. The same is not
working with high
Hi,
I seem to have a problem on one of my databases,
When I log into pgsql I see this:
ERROR: Invalid page header in block 3 of pg_statistic_relid_att_index
Welcome to psql 7.3.4, the PostgreSQL interactive terminal.
When I try to run any command (eg vacuum) I get this message:
db
Hi All,
I am a developer of a product that uses a postgresql database (currently
version 8.2.3.1). We dump the database using pg_dumpall. We are
finding data corruption in the dump files about twice a month with a few
thousand installations. I have been able to track down the data
corruption
Hello,
I am trying to install a postgresql 8.1 shared server. I want each user
to access only its own database through phpPgAdmin. For example, user
“toto” access a database named “toto”, etc.
I used these lines to create the user and his database :
bash-3.2$ createuser toto -P -D -A
Enter pa
Hi here,
I'm trying to make my dump script working but it is not.
I tried to put my password in a .pgpass file into the home directory of
the root user (so /root/.pgpass). Here is a cat of that file :
*:*:*:*:test
(I tried only with stars to be sure my rule was not too strict).
So, il I try thi
Hi,
i'm trying to reorganize a big table without having a downtime at all. I'm
trying to realize this via partitioning and rules.
- step 1 preparation
create table uglybloatedtable (id bigserial, textfield text, primary
key(id));
INSERT INTO uglybloatedtable (textfield) values ('');
INSERT INTO u
I installed pgsql 9.1 on Ubuntu server(10.10). Now I have a problem with
the required env variable LD_LIBRARY_PATH. If I do not set this, I can
not use some pg tools such as pg_dump, createuser...etc. If I set this
variable, my term gets warning "unknown terminal type" for some linux
commands s
I'm on Solaris 10 (Intel) using gcc. I'd like to add /usr/local/lib to
the built-in runpath. I've tried
1. setting LD_RUN_PATH=/usr/local/lib before running configure (also
tried adding this to the command line for configure).
2. Adding LDFLAGS='-Wl,--runpath,/usr/local/lib' to the configure
comman
I'm on Solaris 10 (Intel) using gcc. I'd like to add /usr/local/lib to
the built-in runpath. I've tried
1. setting LD_RUN_PATH=/usr/local/lib before running configure (also
tried adding this to the command line for configure).
2. Adding LDFLAGS='-Wl,--runpath,/usr/local/lib' to the configure
c
Hello...
Here is procedure of making everyday online backup:
1) select pg_start_backup('xxx');
2) tar -cf backup-xxx.tar /mnt/db/pg1
3) select pg_stop_backup();
rm all archived WAL files before special one taken from backup_log
4) tar -cf var-xx.tar /mnt/db/var
Next I'd like to use this copy on
hello, I'm trying to recover files from a backup but I received this :
amrestore: could not fsf /dev/nst0: Input/output error
my cmd : amrestore /dev/nst0 ravenna /var/lib/pgsql/backups
I tried on 2 tapes , but I always have this error :(
---(end of broadcast)
I am having a problem with the rule system in 7.3.4.
I have a view with an on insert do instead rule that is calling a
function and passing new.*. When try to insert a row into the view, I
get ERROR: ResolveNew: can't handle whole-tuple reference.
I was working with this in 8.0 on an R&D projec
In postgresql 7.3.2 if the server shuts down
abruptly then sequence does not behave properly.
Next val after rebooting server shows gsp between
last number & next val
Problem with pg_dump on PostgreSQL 8.05.
How to solve this problem.
Thank you.
$ pg_dump dbname > 080349.sql
pg_dump: socket not open
pg_dump: SQL command to dump the contents of table
"t_visit_service" failed: PQendcopy() failed.
pg_dump: Error message from server: socket not open
pg_dump: The co
Hello:I need help with installationI'm working on a XP Pro box, and trrying to install postgresql 8.1.3 from windows installer. I always installed previous versions without a problem, but recently I've made some changes to user permissions, and now I´m getting this error message:"failed to create p
Dear sir,
I am encountering these errors
-bash-2.05b$ createuser -U postgres -d -A -P dspace
Enter password for new role:
Enter it again:
Shall the new role be allowed to create more new
roles? (y/n) n
createuser: relocation error: /usr/lib/libpq.so.4:
undefined symbol: krb5_cc_get_principal
-bas
I want to have the DD/MM/ date format in my
database without to specify it with:
SET DateStyle='SQL, DMY' at every query.
I tried to modify it in postgres.conf >>>
datestyle = 'European' or datestyle = 'SQL, DMY'
and I tried to make
alter database test5 SET DateStyle='SQL,
DMY';
..
i want to make database in another place and i'm unable to use
initlocation, and i don't know, what i'm doing wrong.
this is what i do, and i think it's correct.
www:/home/db/postgres$ su postgres
[EMAIL PROTECTED]:/home/db/postgres$ ls -l
total 12
drwx-- 6 postgres postgres 4096 Aug 31 14
Hello everybody!
We have a problem with VACUUM FULL and the our PostgresSQL is very slow.
On the try run the vacuum command, its returns:
NOTICE: Child itemid in update-chain marked as unused - can't continue repair_frag
ERROR: No one parent tuple was found
vacuumdb: vacuum nube failed
I t
Hi All
I am working On Postgresql.
i have on Program VET and it's database on Postgresql this programe
run on diff. five Place and all five place separet server. and not connected eachother.
now we want all place data store in one server and data will update Weekly.
how to i backup data whoe
Hello all,
I am new here...
I have a Problem by one of our Applications.
The Frontend ist an Access-Application who connects through ODBC to the
postgres-database (7.3.2).
Two of the three Applications works fine. The other have possibly an Problem with
Sequences.
The Problem is the folowing:
Hi,
I got this error when I run pg_dump:
# pg_dumpall > data_dump
pg_dump: could not find namespace with OID 102548365
pg_dumpall: pg_dump failed on dbsa, exiting
# pg_dump -d dbsa > data_dump
pg_dump: could not find namespace with OID 102548365
# pg_dumpall -v > data_dump
pg_dumpall: dumping d
Dear Ramesh PAtel ,
Will you like to tell us what version are you using
i have three database on one server. when i backup is done complete.
but after backup my pc's speed is very slow. it is requery to restart PC.
try doing vaccumdb
Regards,
V kashyap
---(end o
VERY, VERY URGENT!!
Below is a transcript of an attempt to create a user, which I trust
will be self explanatory.
Who do you think I should go to discuss this problem?
Is there a users' group in which I can post this problem for discussion?
Please help me?
-bash-2.05b$ createuser bruce
Shall
Hi,
As usual I wrote this email because I'm getting problems with posgtresql,
this time is with the pg_dumpall command, here´s the story:
We always make a copy of our database running
[EMAIL PROTECTED]/var/lib/pgsql/bin/pg_dumpall > backup
It always worked fine but lately when I run this comman
HI list,
i have a next function
CREATE OR REPLACE FUNCTION "public"."contador_distrito_activos" (numeric,
numeric, numeric) RETURNS SETOF "public"."ty_activo" AS'
declare
con bigint;
act bigint;
emp alias for $1;
sed alias for $2;
zon alias for $3;
begin
con := contador_distrito(1,2,5)
Hi all,
We are using pg as db for many erp installations.
In general it is working great.
But at the monet I have problem (I think it is database corrupted, but I
am not sure) by running pg_dump.
I receive this message:
pg_dump acc01 > dmpacc01
pg_dump: query to obtain list of data types failed: ER
While compiling 7.4.3 on Solaris 8 (sparc) I got:
rm -f thread.c && ln -s ../../../src/port/thread.c .
gcc -pthreads -O3 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declar
ations -fPIC -I. -I../../../src/include -I/usr/local/include
-I/usr/local/ssl/incl
ude -D_REENTRANT -D_POSIX_PT
HI, I am working on a project, in which a part of it deals with creating a table on different nodes of a Beowulf cluster. Each of the nodes in the cluster is running a postmaster on different cluster. There is one master node in this cluster. I am trying to run the postmaster on the port 9010 on t
When i run the initdb, the following message shown:
We are initializing the database system with username pstan (uid=501).
This user will own all the files and must also own the server process.
initdb: creating template database ini /usr/local/pgsql/data/base/template1
Running: postgres -boot -C
Hi there,
I do a db_dump of my database every night. Recently, this has been
failing, and I have no idea why. Following is a detail (verbose) output
of the dump process... (sorry for the long post, I figured the more info
the better)
-- last builtin oid is 17184
-- reading user-defined type
When I vacuum I get two messages:
NOTICE: Index pg_class_relname_index: NUMBER OF INDEX' TUPLES (108) IS NOT
THE SAME AS HEAP' (82)
NOTICE: Index pg_class_oid_index: NUMBER OF INDEX' TUPLES (108) IS NOT THE
SAME AS HEAP' (82)
I had followed some advice I read in one of these postgres maili
Am running on a RedHat Linux 5.0 Intel box. Now have Postgres 6.2
running on it so I know it works. Have been trying to compile the new
Postgres 6.4.2 with no success. The configure utility seems to run all
right, but running gmake all >& make.log & as the doc's call for exits
immediately wi
Hi!
Can anyone help me with this?
When trying to perform a query it threw : " ERROR: cannot write block
113 of pg_log "
I searched through all the digests and documentation and found nothing.
I've tried vacuuming the base, removing file pg_log, but didn't work.
Any ideas?
Thanks a lot,
After many trials, I do not yet understand the problem that occurs me
when I execute "initdb -l /usr/lib/pgsql -r post -d" on my system.
I report the output below:
Running with debug mode on.
initdb: using /usr/lib/pgsql/local1_template1.bki.source as input to
create the template database.
initdb
Hello,
I have a small database created by the user demo. This database has some
views.
View 'A' uses tables 'X', 'Y', and 'Z' filtered with a column=1;
View 'B' uses same tables, but filtered with the same column=2;
View 'C' uses views 'A' and 'B' to get everything.
Now, with
I'm using postgresql 7.0.2 compiled from the source. I seem to have
things up and working, but I am getting the problem shown below. I can
psql into another database, if I use a different name, and on another
system I can create a database with the name product. I even tried
dropping it and re
All,
I have already posted this message yesterday but didn't get any reply yet...
Please help me with this..I am having trouble doing db authentication with
'pg_hba.conf' file..
I have added two users using 'CREATE USER' command for a db. And then I have
created two separated password file to do
Hello all, I have a problem.
When a try to use EXPLAIN
The optimize don't user the index of primary key.
Why ?
Thanks
Eriko
Hello there,
I am migrating from MySQL to PostgreSQL.
I have built pgsql 7.0.3 on Redhat 7.0.
All of the nevironmental variables have been
set properly. When I try to start the database
server using the following
bash-2.04$ /usr/local/pgsql/bin/postmaster
I get
IpcMemoryCreate: shmget failed
when I am logging on Postgres i haven't to give a password
How can I do in order to have one ?
when I want to pg_dump a database with user postgres, this error appears :
permisson not allowed
whereas with user root it is good
how can i resolve this problem ?
THANKS
__
Hi :
I am having problems in compiling Postgres 7.1.
I am using the following compilers on Solaris 2.8 on a Sparc Ultra 60
machine.
Sun WorkShop 6 update 1 C++ 5.2 2000/09/11
Sun WorkShop 6 update 1 C 5.2 2000/09/11
Is there a port available for this configuration ?
Thanks in advance,
Namrata
I have just installed PostgreSQL7.1.2. I am running
Red Hat 7.1 I uninstalled the PostgreSQL distribution 7.0x which came
together with it using RPM. I downloaded the RPMs for PostgreSQL7.1.2 using RPM.
I started the postgresql service by typing
/etc/rc.d/init.d/postgresql start. The comman
Hi !
I have small problem
amount size all databases ~5Gb
I make dumpall >dumpfile
when size dumpfile = 1024 dumpall print error and exit !
Linux Slackware7.2 ext2 2.4.17 gcc2.95
file size in bash - unlimit
Where is problem ?
Red
---(end of broadcast)-
Hi,
I have a problem with pg_restore. I have a database, named DEPG. I
have taken backup with pg_dump and -Ft options. I created another
database, named test. After this , I used the pg_restore command to
restore the DEPG backup into test database. Then it is restoring upto
some point and faili
On Wed, 20 Feb 2002, Judy Jecelin wrote:
>
> Hi,
>
> I'm at my wits end with this one.
>
> I'm using PostgreSQL 7.1.3 on Solaris 2.8.
> I want to create two databases in the same
> postmaster. I did my initdb and started
> the postmaster. I set two environment
> variables, one for each databas
Hi All,
It is not a Admin question, But it is part of Administration. I would like
store details of groups as well as users in to my dummy table as i inserted
into pg_user as well as pg_group.
for that i created a dummy table for pg_group with same structure.
gdump;
i created a function aa_ins
Hi Folks,
DBMirror had been working very fine till recently. but is facing a problem
currently.
certain "Data" column in the "PendingData" Table which DBMirror.pl script uses
has the stuff below:
"company_id"='78111' "comp_name"='SUBAIDA JEWELLERY' "office_addr"='NEW.43, NSC BOSE
ROAD, ' "ph
I have a dump file I created with pg_dumpall on a 7.0.3 installation.
I'm trying to run 'psql < dumpall.dmp' on a 7.2.3 installation. I set
local connections for all databases to trust in pg_hba.conf, but I'm
still asked for a password. I only have local connection open
(tcpip_socket is set to
On Freitag, 2. März 2007 11:52 isk wrote:
> corrupt tar header found
I'd say your hardware is broken, either memory problem or disk problem.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0676/846 914 666 .network.your.ideas.
// PGP Key
pg_restore -U postgres -d template0 -v -C < file.tar
try using this command
pg_dump -U postgres -h /tmp -o -Ft -b -C mydb > file.tar
From: isk <[EMAIL PROTECTED]>
Reply-To: isk <[EMAIL PROTECTED]>
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Problem with pg_restore
Dat
sl_log_2 !!!??? Do you want to restore slony logs? For why!?
> error report:
> Command was: COPY sl_log_2 (log_origin, log_xid, log_tableid,
log_actionseq, log_cmdtype,
> log_cmddata) FROM stdin;
> pg_restore: [tar archiver] corrupt tar header found in 119 (expected 100,
computed 40443) file
Mageshwaran <[EMAIL PROTECTED]> writes:
> We have our application which uses postgres 7.1.3 version in
> that we use a time functions like now(),timestamp. etc mostly
> timestamp without timezone.We don't need the timezone in that variable
> so we ignore it using timestamp without
"Tony Da Silva" <[EMAIL PROTECTED]> writes:
> When I log into pgsql I see this:
> ERROR: Invalid page header in block 3 of pg_statistic_relid_att_index
I can't think of any reason that a simple connection attempt would be
trying to read pg_statistic. Perhaps you have some nontrivial query
in y
I'm trying upate a group of records. In the table I have 1 field geometry and 2
fields ineteger with long. and lat. everyone. I try to update the field
geometry with point(long lat).
I use this update with numbers and this is ok.UPDATE public."Contenedor" SET
ubicacion = GeomFromText('POINT(1
Hello,
postgres version: 8.2.0.4
platform windows: server 2008
I check connections using:
SELECT pg_stat_get_backend_idset()
Now, I take the output and try to get the ip addresses using
select pg_stat_get_backend_client_addr();
but for a local connection (simple login us
Hello,,
Thank you for your help but it doesn't work with the line :
host toto toto 0.0.0.0 0.0.0.0 md5
I've got the same error message :
FATAL: no pg_hba.conf entry for host "[local]", user "toto", database
"template1", SSL off
Yann
Tommy Cheng wrote:
Try this:
host toto
Hi you need to add following enty 100% it will resolve the problem
# "local" is for Unix domain socket connections only
local all all trust
On Thu, Mar 12, 2009 at 3:21 PM, Yann Collavoli wrote:
> Hello,,
>
> Thank you for your help but it doesn't work
Hi,
If i add this line "local all
all trust", the user "toto" can log in
phpPgAdmin but he can see the others databases. Or, I want each user to
access only its own database through phpPgAdmin (for example, user
“toto” access only at the database named
Yann Collavoli wrote:
Hi,
If i add this line "local all all trust", the user "toto" can log in
phpPgAdmin but he can see the others databases. Or, I want each user
to access only its own database through phpPgAdmin (for example, user
“toto” access only at the database named “toto”). I thi
Hi Yann
For below given purpose you need to create roles and assign them separately
to each database user or revoke the global permission from database and
givepermission to concern user only and also You need to change the
password of global user.this is the best way by which You can achive you
If your users are the database owners, you can set the "Only show
owned databases?" option in the config.inc.php file for your PhpPgAdmin.
Carol
On Mar 12, 2009, at 7:31 AM, BRAHMA PRAKASH TIWARI wrote:
Hi Yann
For below given purpose you need to create roles and assign them
separately to
I have problem with the conection to my database postgres.
I have no problem with the conection in my server (150.xxx.xxx.xxx) and in
the computers with ip near my server. For example if my server
ip is 150.111.111.111 I can connect with 150.111.111.222 or 150.111.111.113
I connect using the follo
Hi,
Thank you very much, with this parameter it works like i want !!
Yann
Carol Walter wrote:
If your users are the database owners, you can set the "Only show owned
databases?" option in the config.inc.php file for your PhpPgAdmin.
Carol
On Mar 12, 2009, at 7:31 AM, BRA
Hello everyone!
First of all: I'm using Postgres 8.2.4 on a WinXP machine.
I'm trying to create a function that creates a new user-role to allow
non-super-users to create users.
The function should look something like that (well, obviously it should
not...but it's to give you an idea, what I
Nicolas Michel writes:
> I tried to put my password in a .pgpass file into the home directory of
> the root user (so /root/.pgpass). Here is a cat of that file :
> *:*:*:*:test
> (I tried only with stars to be sure my rule was not too strict).
> So, il I try this command :
> r...@pc:~ #
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I tried to put my password in a .pgpass file into the home directory of
> the root user (so /root/.pgpass). Here is a cat of that file :
> *:*:*:*:test
>
>psql: FATAL: authentification par mot de passe choue pour
...
> When prompt for
>
>
>
> > I tried to put my password in a .pgpass file into the home directory of
> > the root user (so /root/.pgpass). Here is a cat of that file :
> > *:*:*:*:test
> >
> >psql: FATAL: authentification par mot de passe choue pour
> ...
> > When prompt for a password, I enter 'test' and it
There was indeed a blank after the line (after the password)... ^^
To Scott : yes, I set the file with 0600 permissions ;)
Thank you very much for your help.
Le lundi 18 mai 2009 à 11:59 -0400, Tom Lane a écrit :
> Nicolas Michel writes:
> > I tried to put my password in a .pgpass file into th
I used this following command to set a variable in psql:
\set data_dir '/source_code/lookup/data'
And then I tried to used that variable inside a \copy command like this:
\COPY mytable_lookup FROM :data_dir/mytable_lookup.txt delimiter '|'
I was expecting that ':data_dir' will be repla
hi group,
trying to create foreign key:
ALTER TABLE porder1 ADD CONSTRAINT order_exist
FOREIGN KEY (docuuserid) REFERENCES trade(tradeid) ON DELETE RESTRICT;
column docuuserid is integer in porder1
column tradeidis serial in trade and belong to primary key (single
column)
getting In E
I have a problem database sigiuente sent the message to the console;
LOG: received fast shutdown request
LOG: aborting any active transactions
I wonder what is the problem because the database shutdown services and not
restart automatically.
Atentamente
Alexander Angel
DBA postgres
Venezu
Hi,
I have a doubt about the WAL-based replication. Suppose this situation:
- The PC1(master) write the WAL file in the shared folder in her HD.
- The HD of the PC1(master) dead. The WAL file don't have replicated because
it is a asynchronous proccess and suppose that this already didn't have
ha
Good day,
I have installed postgresql 9.0 on my Debian and thought that restoring
the database would be as simple as psql -f .
However: I get several errors like this:
psql:pgdump.txt.1:4453471: ERROR: character 0xe280a6 of encoding "UTF8"
has no equivalent in "LATIN1"
I have changed the clien
2011/9/17 Rural Hunter :
> I installed pgsql 9.1 on Ubuntu server(10.10). Now I have a problem with the
> required env variable LD_LIBRARY_PATH. If I do not set this, I can not use
> some pg tools such as pg_dump, createuser...etc. If I set this variable, my
> term gets warning "unknown terminal ty
This is my env:
postgres@backup:~$ env
MANPATH=:/opt/PostgreSQL/9.1/share/man
SHELL=/bin/bash
TERM=linux
USER=postgres
LD_LIBRARY_PATH=/opt/PostgreSQL/9.1/lib/
PGPORT=3500
LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;
Wow, you got me.
On Sun, Sep 18, 2011 at 12:56 AM, Rural Hunter wrote:
> This is my env:
> postgres@backup:~$ env
> MANPATH=:/opt/PostgreSQL/9.1/share/man
> SHELL=/bin/bash
> TERM=linux
> USER=postgres
> LD_LIBRARY_PATH=/opt/PostgreSQL/9.1/lib/
> PGPORT=3500
> LS_COLORS=rs=0:di=01;34:ln=01;36:mh=
Tried adding the path to ldconfig rather than redefining ld_library_path?
On 18 Sep 2011, at 09:03, Scott Marlowe wrote:
> Wow, you got me.
>
> On Sun, Sep 18, 2011 at 12:56 AM, Rural Hunter wrote:
>> This is my env:
>> postgres@backup:~$ env
>> MANPATH=:/opt/PostgreSQL/9.1/share/man
>> SHELL=/
yes, tried that too and same thing happened.
于2011年9月18日 17:09:25,Richard Shaw写到:
Tried adding the path to ldconfig rather than redefining ld_library_path?
On 18 Sep 2011, at 09:03, Scott Marlowe wrote:
Wow, you got me.
On Sun, Sep 18, 2011 at 12:56 AM, Rural Hunter wrote:
This is my env:
On sön, 2011-09-18 at 14:56 +0800, Rural Hunter wrote:
> This is my env:
> postgres@backup:~$ env
> MANPATH=:/opt/PostgreSQL/9.1/share/man
> SHELL=/bin/bash
> TERM=linux
> USER=postgres
> LD_LIBRARY_PATH=/opt/PostgreSQL/9.1/lib/
> PGPORT=3500
> LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;
I didn't install anything else there:
postgres@backup:~$ ls -l /opt/PostgreSQL/9.1/lib/
Total 9804
-rwxr-xr-- 1 root daemon 1366272 2011-09-09 13:45 libcrypto.so.6
-rw-r--r-- 1 root daemon 149938 2011-09-09 13:44 libecpg.a
-rw-r--r-- 1 root daemon 18852 2011-09-09 13:44 libecpg_compat.a
-rwxr-x
On sön, 2011-09-18 at 22:41 +0800, Rural Hunter wrote:
> I didn't install anything else there:
(for a very small value of "anything else")
It looks like you have some version of libncurses in there, which is
prone to interfere with the operating system installation.
I suppose you got this instal
On Sun, Sep 18, 2011 at 10:47:39AM +0800, Rural Hunter wrote:
> Any suggestion?
I don't do ubuntu this week, so I may be out to lunch, but
why don't you append to the system set value of the var.
In RH (this week) we do this in /etc/profile.d/localpath.sh
but shirley ubuntu has some means for doin
Well, I installed pg by the official one-click graphic
installer(http://www.enterprisedb.com/products/pgdownload.do). But ahh,
when I tried to get an error message if I don't set LD_LIBRARY_PATH, I
found it's now working without this variable. The variable was added
into my env for 9.1rc. If I
On Sun, Sep 18, 2011 at 8:00 PM, Rural Hunter wrote:
> Well, I installed pg by the official one-click graphic
> installer(http://www.enterprisedb.com/products/pgdownload.do). But ahh, when
> I tried to get an error message if I don't set LD_LIBRARY_PATH, I found it's
> now working without this var
About a month ago, I started receiving quite a few pgstat timeouts on my
production database.
PostgreSQL 9.0.3 on amd64-portbld-freebsd8.1, compiled by GCC cc (GCC)
4.2.1 20070719 [FreeBSD], 64-bit
I am not sure where to start looking for the cause.
Database has been up since march without any
In the last few hours we get a problem with following query in
Production database :
select * from "001".mov_con where number in ( select number from
"001".mov_con where abs(amount-total_amo)>0.1) ;
The correct plan should be
QUERY PLAN
-
Hi, I have a problem installing "plpgsql" in postgreSQL 7.4.6 on linux.
Those Scripts were create succesfull but when i try to create some "store
procedure(function)" no gererate errors, no generate nothing in the pgadmin
III, i don't know what is the problem.
'/usr/lib/postgresql/plpgsql
I'm running PostgreSQL 7.4.7 and have the following
problem.
I have "log connections" enabled in the
configuration file so that I can keep track of who's been logging
on.
The problem is that I also have pg_autovacuum
running which logs on an off constantly and fills up the log with its own
1 - 100 of 671 matches
Mail list logo
