Well, not 100% sure why this would make a difference, but using this
line in pg_hba.conf got things working as I hoped:
hostall all 192.168.0.0/16 ldap "ldap://192.168.0.95/
dc=domainname,dc=company,dc=com;DOMAINNAME\"
-Rob
On Apr 15, 10:30 pm, rob <[EMAIL PROT
company,DC=com"
Any assistance appreciated.
-Rob
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
I am trying to set up a pgsql server, and I don't know too much about
this (or any other) database. When I try to initdb, it dumps telling my
"Error: Unknown type: oidvector"
and then it cleans up, dumps out.
Anybody out there know what is going on?
Rob
[EMAIL PROTECTED]
I am about at wits end. I have been firing off emails, getting no
reply, and it has been about a week and a half. To top this off, I
gotta describe why I am getting nowhere on this database to my boss!
I am attaching the output of initdb, and mind you, this is a FRESH
install, fresh recompile f
udp, tcp) but the error msg talks
about a StreamServerPort bind problem but those unix domain lines won't
be displayed with that set of filters and so it may be some weirdness
with stream and/or lock files in your /tmp directory? Just a guess.
Rob
---(end of b
Tom Lane wrote:
"Siddharth Rath (sirath)" <[EMAIL PROTECTED]> writes:
Surprisingly .s.PGSQL.5432 file is not getting created in /tmp directory ( I believe this should be created).
No, it shouldn't, because that is associated with the creation of the
Unix socket file, which happens after creation o
Siddharth Rath (sirath) wrote:
Hi Rob,
I did run the script from http://myclass.missouri.edu/~atb6x2/NETSERV/NS_serverpl.html and it didn't give any error and the O/P of
netstat -plunta | grep 5432
(Not all processes could be identified, non-owned process info
will not be shown, you would ha
Siddharth Rath (sirath) wrote:
Hi Rob,
Please find the output of "strace -f /apps/systran/postgresql/bin/pg_ctl start -D
/apps/systran/postgresql/data-linux > s.out 2>
s.err" in the below provided URLs:
http://us.f2.yahoofs.com/bc/40c0ea30_116c8/bc/My+Documents/s.err.err?bfd6O
possible to overload auth types like this such
that if pam fails password would be tried?
Many thanks in advance,
Rob Cherry
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan
Got this problem:
[rob@bloodyaxes bin]# su postgres -c "initdb
--pgdata=/var/db --pglib=/usr/local/pgsql/lib"
We are initializing the database system with
username postgres (uid=100).This user will own all the files and must also
own the server process.
Creating template d
, configure, make, make install all succeeded. Without doing
initdb, 7.3.3. data directory still in original place, I tried starting
postgresql but got:
IpcMemoryCreate "Function not implemented"
This refers to the ipc daemon but it's verified running.
Any ide
Trying to configure --with-java but make is failing with: (see below
for other details)
Any ideas?
Thanks,
Rob
-->./configure --enable-shared --with-maxbackend-connections=256
--with-perl --with-java
-->make
.
.
.
make[3]: Entering directory
`/home/postgres/postgresql-7.4.5/src/inte
approve ErbNNx unsubscribe pgsql-admin
[EMAIL PROTECTED]
_box_ops
gist | gist_int4_ops
gist | gist_poly_ops
gist | gist_timestamp_ops
The create index statement that is failing the restore:
CREATE INDEX idx_disc_loc ON order_items USING gist (disc, loc);
Has anyone battled this one before? Is there a problem with
dumping/restoring with blobs?
Attached.
The previously posted index failure stated:
CREATE INDEX idx_disc_loc ON order_items USING gist (disc, loc);
However in this list it is:
CREATE INDEX idx_item_loc ON content_items USING gist (disclosuer, loc);
Rob
Tom Lane wrote:
> "Rob Long" <[EMAIL PROTECTED]>
Tom,
Will this be fixed in 7.4?
Thanks for the support.
Rob
- Original Message -
From: Tom Lane <[EMAIL PROTECTED]>
Date: Thursday, October 2, 2003 6:28 pm
Subject: Re: [ADMIN] pg_restore fails - postgres 7.3.4
> "Rob Long" <[EMAIL PROTECTED]> writes:
> &g
_box_ops
gist | gist_int4_ops
gist | gist_poly_ops
gist | gist_timestamp_ops
The create index statement that is failing the restore:
CREATE INDEX idx_disc_loc ON order_items USING gist (disc, loc);
Has anyone battled this one before? Is there a problem with
dumping/restoring with blobs?
wondering if anyone else thought it might be a good idea (or not)
to use this ?
Cheers,
Rob
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
n and
replacing it with a freshly pg_dumped version.
Is it possible to 'fix' any of the pg_ tables by hand to solve this
cache lookup error?
The master DB is 7.3.4, the version on my workstation is 7.3.2.
If it's not possible, I'll have to do a dump and restore, which is a
I am trying to find
a way of performing something similar to the SQL-Server SQL of
IF NOT EXISTS
(SELECT id FROM a_table WHERE id='akey')
THEN INSERT INTO
a_table (id, name) values ('akey', 'adetails');
ORM] WAL Optimisation - configuration and
usage"). I'm still experiementing with good settings for checkpoint_seg
and timeout however the significance of recycling and
checkpoint_segments worries me slightly. I shall try lower values in the
mean time.
Best regards,
--
Rob Fielding
Another thought -
We had a similar issue recently. Our support guys dropped the database and
then rebuilt it from a dump file. The size of the data directory went down
from 12GB to less than 2GB. According to the sys ad that did the work
postgres is not very good a reclaiming disk space
1206742658
(4 rows)
So, is autovacuum doing it's job?
Many thanks,
Rob Newton
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
rning.
- Rob
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Greetings!
In an attempt to satisfy our client's requirements for redundancy, we
ended up with an unusual (at least to my inexperienced eyes) system
configuration. Our client has two buildings that use our application.
Each building has an application server and a storage server. All are
runnni
I have a customer who is running PostgreSQL 8.1. I recently updated an
application there, and it is running extremely slowly. The previous
version of the application runs fine, and the new version runs fine on
my machine, which runs PostgresQL 8.4. The problem is that a query for
a single record
is highly appreciated.
>
> Thanks in advance
> Thomas
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Rob Wultsch
wult...@gmail.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
s of disk but not much ram or cpu.
#2: lots of ram and cpu but not much disk.
Could it make sense to have box #2 run pg while mounting the fs of box #1?
--
Rob Wultsch
wult...@gmail.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://w
subscribe from these mailing list
via the like at the bottom of every message. I think this would be a
good idea. I would like to take this one step further and suggest you
unsubscribe from this plane of existence.
Nothing personal but you are dragging down the species,
Rob Wultsch
--
Sent via pg
I thought I sent this earlier, but it's not in my Sent box, so I'll try
again.
Your solution maintains an exact copy of two tables. Whenever a record
is updated in the first, it is updated in the second, and you have lost
information about the previous value.
Whenever I do anything like this,
Greetings!
I am putting together a formal installation package for a customer who
is not happy if he doesn't have one, even though he's got primary and
backup servers both running as expected.
I am writing instructions on how to install PGAgent. The download
package for PGAgent includes
Greetings!
I want to install the Postgres ODBC driver version 8.04 for a customer
that is currently using 8.01. However, I cannot make any change to the
customer's computer without being able to undo the change in case
something goes wrong. The customer has a spare computer that we have
been
I have a Postgresql 8.3 instance with tablespaces totalling on about 74G. This
is fine.
But if I ask Postgresql how big my database is, I get a (unexpected) large
answer: 595 GB.
This seems very strange. Disk I/O tests on the system are in the 'normal'
range, but queries are slower than they u
>On Wed, 2011-09-14 at 04:03 -0700, Rob Audenaerde wrote:
>> I have a Postgresql 8.3 instance with tablespaces totalling on about 74G.
>> This is fine.
>>
>> But if I ask Postgresql how big my database is, I get a (unexpected) large
>> answer: 595 GB.
>&g
size(tablename) ) as disksize
, pg_total_relation_size(tablename)
from pg_tables where schemaname <> 'information_schema'
order by 2 desc
And all the tables report a 'disksize' larger than the 'relsize', which seems
natural. The biggest table (relsize) is around
r the statistics of the old database to the new one,
so we can reuse the statistics? Or is there a better alternative to achieve the
same?
Kind regards,
-Rob
ident" auth for local connections such
that all users can log in as themselves based on their OS authenticated
username, but I would further like to allow for named admin users to log in
as the privileged account. In the following example there is only 1 user
defined in postgres - the "postg
Very naïve question here: Why would you want to save the data from the first
insert?
I thought the purpose of a transaction was to make sure that all steps in the
transaction executed, or none of them executed. If Oracle saves half of the
data between the beginning and ending of the transact
I've seen lots of questions about this on the Internet, but no answers.
I've got PostgreSQL 8.4 and 9.1 both installed on my computer. I am trying to
set up a scheduled database job to support application testing. The problem is
that I do not seem to have any of the files required to install p
Does the output from 'ps' mean the master/slave are in sync, or is the slave
really still playing catchup (based on the names of the logfiles in pg_xlog) ?
Cheers,
Rob.
Isn't that basically what replication is supposed to do?
RobR, quite possibly revealing his ignorance about replication.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
PLEASE REMOVE ME FROM [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: explain analyze is your friend
:
ERROR: can't create lock file -- another vacuum cleaner running?
Should I get worried and keep my backup close at hand?
Rob den Boer-HRS
m is ran from a background process that collects data
all day, and around midnight it does a dump_all and after that a vacuum.
> Also, I don't know is this in FAQ or not: after getting FATAL
> you should restart postmaster.
Thanks for mentioning it, it didn't see/found this one.
regards,
Rob den Boer
I cannot get the postmaster to start up in SSL mode. I receive the following
error:
bad permissions on private key file (/var/lib/pgsql/data/server.key)
I've checked the permissions and everything seems to be fine.
ls -al
total 56
drwx--6 postgres postgres 4096 Dec 18 17:17 .
drwxr-
buf.st_uid != getuid())
> {
> postmaster_error("bad permissions on private key file
> (%s)", fnbuf);ExitPostmaster(1);
>
> so my guess is that you have to remove group/other permissions on the
> file.
>
> -------
Does anyone have a good recipe for a view that will display users/gruops in a
way that can be used with Tomcat's JDBCRelam configuration? In other words,
instead of seeing a *list* of users in a group (grolist), I'd like to see a
separate row for every group/user combination.
group | user
---
Is there any problem with this line from my pg_hba.conf file:
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all 0.0.0.0 0.0.0.0 md5
I get this error when I try to connect:
LOG: parse_hba: invalid syntax in pg_hba.conf file at line 90, token "0.0.0.0"
FATAL: Mis
How does postgres calculate the MD5 version of a password to store in the
database during user creation? I am trying to set up a postgres JDBCRealm to
work with Tomcat. The problem is that the resulting digest from Java is
different then the digest stored in the database for the same word.
cl
Perl also came up with the same digest as Java.
--
Robert Abernethy IV
Dynamic Edge, Inc.
734.975.0460
> How does postgres calculate the MD5 version of a password to store
> in the database during user creation? I am trying to set up a
> postgres JDBCRealm to work with Tomcat. The problem is
Can you tell postgres *NOT* to use a salt when calculating the MD5 digest? I
found that it prepends the username to the password before making the calculation.
--
Robert Abernethy IV
Dynamic Edge, Inc.
734.975.0460
> Perl also came up with the same digest as Java.
>
> --
> Robert Abernethy IV
>
, Inc.
734.975.0460
> "Rob Abernethy IV" <[EMAIL PROTECTED]> writes:
> > Can you tell postgres *NOT* to use a salt when calculating the MD5
> > digest?
>
> No, and you wouldn't want to. The salt is an essential security
> feature.
The username is the salt.
--
Robert Abernethy IV
Dynamic Edge, Inc.
734.975.0460
> I am trying to figure out exactly how to set someone's password when
> using MD5 passwords in postgres. I am trying to automate some
> features, and still can't figure out what I am doing wrong. MD5 of
> the
nections:
hostall all ::1/128 md5
# Internal network
hostall all 192.168.0.0/24md5
Now I have a client PC 192.168.0.10, it's also running Linux and the
unix account name on this machine is rob. I have the postgres client
installed
gt; On Thu, 1 Mar 2007, Rob van der Linde wrote:
>
> > On that server I have a user account, called "ynui", and I also have a
> > postgres user called "ynui", they have the same password. Now the
> > server's IP is 192.168.0.1
> >
> >
55 matches
Mail list logo
