SchemaSpy is kind of handy.
Bob
Sent from my iPhone
On Sep 4, 2012, at 11:35 AM, Craig James wrote:
> Can anyone recommend a good tool for producing a good drawing of an existing
> database schema? I don't need a design tool, but rather one that can take an
> existing schema
ma seewhat to al_low;
set search_path to seethat, seewhat, public;
create table seethat.open(open_id int);
create table seewhat.closed(closed_id int);
set session authorization al_low;
\d
set session authorization dee_ny;
\d
Hope that helps!
Bob Lunney
- Original Message -
From: Juan Cu
drop
and create new partitions to clear out and populate data quite quickly. Check
out http://www.postgresql.org/docs/8.4/interactive/ddl-partitioning.html for
details of partitioning in PG 8.4.
Good luck!
Bob Lunney
- Original Message -
From: David Ondrejik
To: pgsql-admin
Cc:
Se
s (ACID properties) to manage the documents you may
be stuck. If not, replace doc_data with doc_filename (or maybe file_n is that
column already) and move on from there.
Good luck,
Bob Lunney
Στις Wednesday 20 July 2011 17:31:45 ο/η pasman pasmański έγραψε:
> You may do a backup of this ta
overage of different table sets works great, and my overall
dump times have been reduced to one-fifth the time it takes to run a single
pg_dump.
BTW, I'm using PG 8.4.1, going to 8.4.8 soon, and its working great. Thanks to
all for the excellent database software.
Regar
store -Fc > /dev/null
I get
pg_restore: [custom archiver] found unexpected block ID (4) when reading data
-- expected 4238
I suspect that locks are colliding sometimes and not others, but I'm not sure.
Little help?
Thanks in advance,
Bob Lunney
--
Sent via pgsql-admin mailin
Schema Spy works for me.
Bob Lunney
--- On Wed, 5/18/11, neubyr wrote:
> From: neubyr
> Subject: [ADMIN] visualizing database schema - png/jpeg?
> To: [email protected]
> Date: Wednesday, May 18, 2011, 3:09 PM
> Anyone knows of tools that can
> generate PNG/JPE
Mark,
Comments inline below for items 2 and 3. What you are planning should work
like a charm.
Bob Lunney
--- On Wed, 4/27/11, Mark Stosberg wrote:
> From: Mark Stosberg
> Subject: [ADMIN] best practice for moving millions of rows to child table
> when setting up partitioning?
&g
purposes, so the
list of tables should come from:
select relname
from pg_class c
join pg_namespace n on c.relnamespace = n.oid
where nspname = current_schema()
and relkind = 'r'
and c.oid not in (
select indrelid
from pg_index
where indisprimary or indisunique
)
order by 1;
Bob Lunney
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Marc,
Try pg_stat_user_tables - it will eliminate the tables in pg_catalog,
information_schema, and the toast tables.
Bob Lunney
--- On Wed, 3/30/11, Marc Fromm wrote:
From: Marc Fromm
Subject: [ADMIN] grant select script
To: "[email protected]"
Date: Wednesday, March 30,
ey will start using the new table.
Foreign keys and other constraints may complicate things a bit, so check those
out first. Also, don't forget to index and analyze the new table before the
switch over.
Good luck!
Bob Lunney
--
Sent via pgsql-admin mailing list ([email protected]
Sorry, I should have included the fact that PG was compiled from source on the
same machine where it runs using gcc 4.1.0, and config.log has:
./configure --with-python --with-gssapi --enable-thread-safety
Bob Lunney
--- On Mon, 3/7/11, Bob Lunney wrote:
> From: Bob Lunney
> Subject:
r over a year. It has Slony
replicating to another mirror image server that has not had any problems
whatsoever.
Any ideas?
Thanks in advance for all your help, and especially for the amazing database
software!
Regards,
Bob Lunney
--
Sent via pgsql-admin mailing list (pgs
Brad,
Google for "SQL Power Architect", download it, and try a schema comparison.
That might get you a ways down to road to what you want.
Bob Lunney
--- On Wed, 1/19/11, French, Martin wrote:
From: French, Martin
Subject: Re: [ADMIN] Postgres Backup Utility
To: "Bradley Holbr
Run ulimit -a and verify the max memory size allowed for the postgres
account.(I assume you are running postmaster under the postgres account,
right?) The allowed size should be large enough for the postmaster plus shared
buffers and several other GUCs that require memory.
Bob Lunney
Run ulimit -a and verify the max memory size allowed for the postgres
account.(I assume you are running postmaster under the postgres account,
right?) The allowed size should be large enough for the postmaster plus shared
buffers and several other GUCs that require memory.
Bob Lunney
Run ulimit -a and verify the max memory size allowed for the postgres
account.(I assume you are running postmaster under the postgres account,
right?) The allowed size should be large enough for the postmaster plus shared
buffers and several other GUCs that require memory.
Bob Lunney
Glen,
Did you drop the indexes prior to the restore? If not, try doing so and
recreating the indexes afterwards. That will also speed up the data load.
Bob Lunney
--- On Mon, 2/15/10, Glen Brown wrote:
From: Glen Brown
Subject: [ADMIN] pg_dump/restore problems
To: [email protected]
be appreciated. I've scoured Google but can't find the
missing piece of information I need to get Windows clients working. Thanks in
advance!
Bob Lunney
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Mark,
Look into kerberos. You will have to recompile your server to use it.
Bob Lunney
--- On Thu, 8/5/10, Mark Steben wrote:
> From: Mark Steben
> Subject: [ADMIN] password administration
> To: [email protected]
> Date: Thursday, August 5, 2010, 3:58 PM
>
>
&
Silvio ,
I had a similar problem when starting the database from an account that didn't
have the appropriate ulimits set. Check the ulimit values using ulimit -a.
HTH,
Bob Lunney
--- On Thu, 8/5/10, Silvio Brandani wrote:
> From: Silvio Brandani
> Subject: [ADMIN] out of m
nexpected EOF on client
connection
10.192.2.1(41547):2010-06-24 18:06:09.958 EDT:LOG: disconnection: session
time: 0:00:00.071 user=rep_usr database=main_db host=10.192.2.1 port=41547
Thanks in advance for your help!
Regards,
Bob Lunney
--
Sent via pgsql-admin mailing list (
n the new table. That
way you won't have to worry about the trigger firing at all.
Bob Lunney
==
create table blah (blah int, ts timestamptz);
create function update_timestamp() returns trigger as $$begin new
If you're using Tomcat or some other Java container that does connection
management restart it and the lock should go away.
Bob Lunney
--- On Fri, 4/30/10, Kamcheung Sham wrote:
> From: Kamcheung Sham
> Subject: [ADMIN] Runaway Locks
> To: [email protected]
> Date:
Suresh,
The real question is: does manipulation of the images have to be
transactional? If so, store them in the database. If not, store the images in
the file system and put the file name in the database, thereby avoiding
unecessary WAL overhead.
Bob Lunney
--- On Wed, 4/7/10, Suresh Borse
ct user1.session_id from user1.sessions;
>
> when I could do it in a single query especially since the
> database is
> remote and secured with SSL.
>
> Thanks - John
>
John,
How about creating a central admin schema and putting a trigger on all the
sessions tables to writ
I recently saw a similar issue. It is two-fold:
1. I used "su -" to become the postgres user, and inherited the previous
account's memory limits,
2. AfterTriggerEvents queues are caused by foreign key constraints, one per
row. If you're loading data, dropping or disabling that constraint makes a
world of difference. Just be sure to check afterwards if the RI has been
violated prior to recreating the FK constraint.
Bob
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
r and restarting
the database, but to no avail. Is there another method that doesn't involve
running a dump, initdb, and restore?
Thanks in advance,
Bob Lunney
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.post
e same disk drive, anyway) in Windows simpy rejigger the file descriptor and don't reallocate any disk space. I haven't tried it yet, but I'm moving in that direction.Regards,Bob Lunney--- On Tue, 12/2/08, Ward Eaton <[EMAIL PROTECTED]> wrote:From: Ward Eaton <[EMAIL PROTEC
s 5 -t .\pgsql.trigger.5442
..\data\archive %f %p %r 2>>pg_log\standby.log'
I found this on the forums. Could it be the source of the problem I'm
experiencing?
Thanks in advance for the wizardly advice!
Bob Lunney
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
>
> Why use to_number or to_timestamp? I assume you are using setString
> in your prepared statement. In your Java code you can use setNull if
> the value is null and setInt or setLong or setTimestamp if it is not.
> Then you don't need the to_number or to_timestamp.
You're absolutely right.
Hello all,
I'm a newbie. PostgreSQL 8.1.4. Fedora Core 5.
I'm writing a small java application that will import CSV txt files into
my DB. The SQL statement I'm sending to pgsql looks like this:
"INSERT into table (col1,col2,col3) values (to_number(?,
'999'),to_timestamp(?, 'MM/DD/ HH24:MI:
Trying to connect from an ASP.NET front end to a Postgresql
814 backend.
ODBC is connecting but get this error on some pages:
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current
record has been deleted. Requested operation requires a current record.
/index.asp
27;s table description, or is
there actually a functional difference? Should I re-define all the
other foreign key constraints to be safe?
Thanks!
Bob Smith
Hammett & Edison, Inc.
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
UNSUBSCRIBE
package, dcm3che, suggest
only one file needs to be copied to one of its' folders.
I have searched the IBM and Postgres sites and have been overwhelmed with
the volume of information, but I can't find the specific piece of
information that I need.
Thanks for your help.
B
unsubscribe
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi all,
Can I restrict the number of emails to certain keywords with a filter?
I am getting too many irrelevant emails (but I do not want to stop all the
emails from [ADMIN]!
Regards,
Bob Wheldon
[EMAIL PROTECTED]
Tel. +49 8444/7309
---(end of broadcast
162 days, 17:48, 3 users, load averages: 0.57, 0.51, 0.51
Maybe I should have a cron script restart postmaster every now and
then, like once a week?
Bob
On Wednesday, Mar 5, 2003, at 10:11 US/Pacific, Bob Smith wrote:
When I execute a query on a new connection, the performance is many
times
the life of one backend process? If
so, is there any way to make this caching persistent across backends?
Server particulars:
Postgres 7.2.1, Mac OS X Server 10.1.5, dual 1GHz CPUs, 1.5GB memory
Thanks!
Bob Smith
Hammett & Edison, Inc.
[EMAIL PROTECTED]
-
he separate parts of the UNION query? In other words, could a
row appear to be missing or duplicated because a transaction that was
moving the row from pending to permanent committed while the UNION was
running?
Thanks!
Bob Smith
Hammett & Edison, Inc.
[EMAIL PROTECTED]
g from the postmaster's process. Sounds like I need the
assistance of an OS X expert, I'll try some OS X related discussion
groups.
Thanks for your help!
Bob Smith
Hammett & Edison, Inc.
[EMAIL PROTECTED]
On Tuesday, July 9, 2002, at 08:03 , Tom Lane wrote:
> Bob Smith <[EMAIL
to be working just fine. Anyone
know what this message means, or how to make it stop?
Bob Smith
Hammett & Edison, Inc.
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi again,
How can I log into news.postgresql.org to follow the messages in the
news groups. I am using Mozilla-0.9.8 and don't seem to be able to get it
to see any of the lists.
Thanks,
Bob
--
Bob Hartung, Bettendorf, IA
---(end of broa
x27;m going to stop worrying about it.
Thanks much for your help!
Bob Smith
Hammett & Edison, Inc.
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Friday, March 15, 2002, at 09:53 , Tom Lane wrote:
> Bob Smith <[EMAIL PROTECTED]> writes:
>> PostgreSQL 7.0.2
>
> Time to update ...
I know, I know... But I'm about two weeks from bringing a whole new
server on-line with the latest version of Postgres, so I
safe?
Advice much appreciated!
Bob Smith
Hammett & Edison, Inc.
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ith just the select statement, then drop ALL the indexes
on contact, do the update, then recreate the indexes.
Bob Hairgrove
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscri
#x27;d still like to know if I might eventually have to re-
build the whole site due to running out of OIDs.
The server is a P3-800, 768MB RAM, 80GB disk, running Red Hat 7.0
and PostgreSQL 7.0.2.
Thanks!
Bob Smith
Hammett & Edison, Inc.
[EMAIL PROTECTED]
--
On Thu, Dec 20, 2001, 18:55:18 Tom Lane wrote:
>[EMAIL PROTECTED] (Bob Smith, Hammett & Edison, Inc.) writes:
>> On a related note, does anyone know if 'current' works with DATE?
>
>DATE does not have an internal representation of 'current', so the DATE
&
est where not(date = null);
key |date
-+
1 | 2001-12-20
2 | 2001-12-20
(2 rows)
rsj=>
|\ _,,,---,,_Bob Smith
/,`.-'`'-. ;-;;,_Hammett & Edison, Inc.
|,4- ) )-,_. ,\ ( `'-' [EMAIL PROTECTED]
'---'
I've discovered this huge file, >16Meg, in the data/pg_xlog
directory but information for it is alluding my discovery too.
What is it and how can i manage it? Can it be deleted or is
some tool necessary to deal with it?
--
Bob Himes
Pure Matrix, Inc.
303-245-1045ext.
"G. Anthony Reina" wrote:
> We have three databases for our scientific research and are getting
> close to filling our 12 Gig partition. My boss thinks that just getting
> a really big (i.e. > 30 Gig) SCSI drive will be cheaper and should do
> nicely. Currently, we only have 4 people accessing th
When loading a dumped database I get the ERROR message
psql:/tmp/savedump:574: ERROR: btree: index item size 3128 exceeds
maximum 2717
The database was dumped from postgresql 6.5 using that versions
pg_dumpall and was loaded into postgresql 7.0
Any ideas?
Bob
--
Bob Cregan [EMAIL PROTECTED
Hello all. I hope this is the right place for this question. On a
machine called falstaff.trgrdc.mc.xerox.com, IP address 13.137.84.27,
I've got the following pg_hba.conf:
localalltrust
host all 13.137.84.27 255.255.255.255
I ran into the same thing.. it must be a reserved word..
--Bob
-
You got two choices jack: start talkin' or start hurtin'
-- Mr. T
On Wed, 1 Mar 2000, Andre Antonio Parmeggiani wrote:
>
> Hi All,
>
> I tried to create a silly
hing that
talks about this..
Does anyone know how I can move my databases over?
Thanks,
--Bob
ccess
side Posix/Y2K compliant?
Thanks in advance for any assistance.
Regards - Bob Kruger
readline or history libraries.
Has anyone who is running slakware gotten this feature to work properly?
Thanks in advance for any assistance.
Regards - Bob Kruger
I am prepping to upgrade from version 6.4.2 to 6.5.
Could someone point me in the right direction for a method to preserve user
names and passwords during the upgrade?
Thanks in advance for any assistance.
Regards - Bob Kruger
some of the archive and not seen
this text).
Any suggestions how can I go about debugging this please?
TIA,
Bob
Bob Parkinson
[EMAIL PROTECTED]
--
Technical Officer: OMNI projecthttp://omni.ac.uk/
Greenfield Med
What am I missing? Is this a bug in the rpm?:
I just upgraded using the Red Hat 6.4.2 rpm (from 6.3).
Now I get a compile time error:
cc -g mail2sql.c -o mail2sql -lpq \
-I/usr/include/pgsql
/usr/lib/libpq.so: undefined reference to `crypt'
collect2: ld returned 1 exit status
__
me of the postings archived on this problem but
didn't see any solutions. Does anyone have any idea what might be going
on here.
Thanks in advance
Bob Dilworth
Toledo Ohio
[EMAIL PROTECTED] (home)
[EMAIL PROTECTED] (work)
64 matches
Mail list logo
