Thanks, guys. Worked like a charm.
Carol
On Aug 25, 2009, at 6:25 PM, Scott Marlowe wrote:
On Tue, Aug 25, 2009 at 2:25 PM, Carol Walter
wrote:
This may be a silly question but I don't see any place where the
documentation explicitly addresses whether or not you can designate a
parti
This may be a silly question but I don't see any place where the
documentation explicitly addresses whether or not you can designate a
particular column as a primary key after the table is created. I used
the "create table as " syntax to create a table with the same columns
as an original
might have caused this behavior?
Carol
On Jul 24, 2009, at 1:39 PM, Carol Walter wrote:
I'm running Solaris 10.
Carol
On Jul 24, 2009, at 3:07 AM, Julius Tuskenis wrote:
#---
# CONNECTIONS AND
I'm running Solaris 10.
Carol
On Jul 24, 2009, at 3:07 AM, Julius Tuskenis wrote:
#---
# CONNECTIONS AND AUTHENTICATION
#---
# - Connection Setting
x27;t connect. I think the pg_hba.conf file is
fine. Where else should I be looking?
Carol Walter
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
no difference.
Carol
On Jul 15, 2009, at 2:22 PM, Chander Ganesan wrote:
Carol Walter wrote:
Well, that is a definite possibility. When I try to log in to the
8.2.10. instance from another machine on our network, I get an
authentication error. The error log says that authentication is
o Herrera wrote:
Carol Walter wrote:
In May, I upgraded our postgres installation to 8.3.6, but I still
had
two databases running on 8.2.4. I had tested moving to 8.2.10 on
another location. Last Friday something happened to the disk where
the
8.2.4 instance was running. I was, quickly,
Hello,
In May, I upgraded our postgres installation to 8.3.6, but I still had
two databases running on 8.2.4. I had tested moving to 8.2.10 on
another location. Last Friday something happened to the disk where
the 8.2.4 instance was running. I was, quickly, able to get the
8.2.10 test
Hello,
I've got a web site that broke when we experience some system
problems. The site was built using ezSQL. I need to specify a port
for the connection string. Does anyone know what the argument is
called in ezSQL?
Thanks, in advance.
Carol
--
Sent via pgsql-admin mailing list (pg
Hello,
I am creating an application in PHP that accesses a Postgres
database. This application works, but I have been unable to perform a
database task that is extremely important. My application is a admin
app that allows a user to insert records into several tables in a
database. The
I think that permissions on the parent directories can result in this
error.
Carol
On Jun 26, 2009, at 1:07 PM, Kevin Grittner wrote:
Andy Shellam wrote:
don...@caltech.edu wrote:
Unable to connect to PostgreSQL server:
could not connect to server: Permission denied
Is the server running
This did fix my problem. I thought that it was a constraint because
the error message I got said that the action was violating the unique
constraint. I didn't realize until later that actually meant the
unique constraint on the index,
I'd be interested in the question here, as well.
Caro
On May 5, 2009, at 12:08 PM, Tom Lane wrote:
Carol Walter writes:
I don't know how they did this, but I have a table that has a
compound
field constraint. When I try to insert data into this table from an
app I'd developing the query fails because the data supposedly
violates
Hello,
I don't know how they did this, but I have a table that has a compound
field constraint. When I try to insert data into this table from an
app I'd developing the query fails because the data supposedly
violates the unique constraint on these fields. The fields are first,
middle,
Hello,
Some weeks ago, I was trying to get full text searching working on my
8.2.4 instance of Postgres. Since tsearch2 is now included in the
core and I was in the process of upgrading to 8.3.6, I decided to wait
until I had 8.3.6 up and running instead of basically working on
tsearch t
Greetings,
Is there a way to build just the binaries? My users connect from
another machine. The libraries are not in the same place on the
machine. I don't want to add the load library path to their profiles
because there are two instances of postgres they need to get to and
the libra
That would be a better plan, but I don't know what they are. Is there
an integrity check utility that will run the databases and check this?
Carol
On Mar 13, 2009, at 12:18 PM, Scott Marlowe wrote:
On Fri, Mar 13, 2009 at 10:17 AM, Carol Walter
wrote:
Thanks so much. That
Thanks so much. That's what I needed to know. I'm going to have to
make some modifications to my script so that it reports what databases
it's loading, and take steps to change the data types or, at least,
hold them out.
Carol
On Mar 13, 2009, at 11:13 AM, Alvaro Herrera
I'm upgrading my Postgres 8.2.4 instance to 8.3.6. I will eventually
have two instances of 8.3.6, but for a time those databases that will
be migrated to the second 8.3.6 instance will need to stay on the
8.2.4. The 8.2.4 instance is running on port 5432 and the 8.3.6
instance is running
I'm moving from PostgreSQL 8.2.4 to PostgreSQL 8.3.6. When I restore
the databases from the old instance to the new one, I get a lot of
errors where the data types in keys don't match, e.g. the data type is
integer in the base file but defined as numeric in the file that it is
linked to.
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 want to recreate users with their passwords from one database
cluster on another database cluster. What would be the best way for
me to do this?
Thanks,
Carol
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
On Mar 6, 2009, at 11:10 AM, Tom Lane wrote:
Carol Walter writes:
Well, it seems like that could happen. This is a machine that has a
instance of 8.2 running on it. My bash history says that the command
that I ran to start the 8.3.6 instance is
pg_ctl start -D /db02/postgres/data8.3.6/data
On Mar 6, 2009, at 10:37 AM, Tom Lane wrote:
Carol Walter writes:
I am building a test instance of PosgreSQL 8.3.6 on a Solaris 10 box.
When start the server, if fails to start. In the log there are these
statements...
-bash-3.00$ more data836.log
FATAL: unrecognized configuration
Hello,
I am building a test instance of PosgreSQL 8.3.6 on a Solaris 10 box.
When start the server, if fails to start. In the log there are these
statements...
-bash-3.00$ more data836.log
FATAL: unrecognized configuration parameter
"default_text_search_config"
FATAL: unrecognized con
Hello, again,
I solved my own problem. The LD_LIBRARY_PATH was not set.
Carol
On Mar 5, 2009, at 3:27 PM, Carol Walter wrote:
Greetings,
This is on a Solaris 10 box. Did I shoot myself in the foot by
trying to do a completely clean install?
I'm installing version PostgreSQL 8.3.6
Greetings,
This is on a Solaris 10 box. Did I shoot myself in the foot by trying
to do a completely clean install?
I'm installing version PostgreSQL 8.3.6 as a test. I want to take it
live in two weeks. I installed it configured and ran gmake once and
it seemed to work fine, but I didn
On Mar 4, 2009, at 4:53 PM, Scott Marlowe wrote:
On Wed, Mar 4, 2009 at 2:40 PM, Carol Walter
wrote:
This has happened or is happening to me again, only this time, it's a
database that I just created. I restored another database into a
test
database. One of the tables is empty. I
wrote:
Have you got any copies of psql or tools like pgadmin open. I've
been caught out by this. try
select * from pg_stat_activity
it should tell you what connections are open on the table (look at
the datname column)
Carol Walter wrote:
This has happened or is happening to me again,
Carol
On Mar 2, 2009, at 8:31 PM, Tom Lane wrote:
Carol Walter writes:
I'm not sure I understand. If there is a lag time between when
someone exits the database and when the database "knows" that no one
is still in it, then that shouldn't be the problem here. I tried a
n
That's interesting and is probably the answer to my question as to why
this happens. Thanks, Nick. What it doesn't explain is why I was
able to connect to a test database using PhpPgAdmin and close the
browser, without logging out, and I was able to rename my test
database. I couldn't re
I'm using psql from the command line. Doing an ALTER DATABASE command.
Carol
On Mar 3, 2009, at 2:36 AM, Julius Tuskenis wrote:
Hello, Carol.
how exactly are you trying to change the DB name? In console or
using some management tool like pgAdmin?
Carol Walter rašė:
Periodicall
couldn't reproduce the condition.
Carol
On Mar 2, 2009, at 8:31 PM, Tom Lane wrote:
Carol Walter writes:
I'm not sure I understand. If there is a lag time between when
someone exits the database and when the database "knows" that no one
is still in it, then that shouldn'
it always reported that the database was in use. No one was logged in
but me, but the database still reported that the database was in use.
I was connect to template1 and trying to rename the other database
from there.
Carol
On Mar 2, 2009, at 4:23 PM, Tom Lane wrote:
Carol Walter
n use. This particular database is in a 8.2.4 release.
I'm moving to 8.3.n but I'm not there yet.
Carol
On Mar 2, 2009, at 3:32 PM, Tom Lane wrote:
Carol Walter writes:
Periodically, my databases will give me a message that says that
someone is using the database when it appears
Periodically, my databases will give me a message that says that
someone is using the database when it appears that no one is. What
causes this? What can I do about it?
Thanks,
Carol
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
ht
e point
me at documentation that tells me enough of what is going on "under
the hood" for me to figure out how to proceed.
Thank you so much,
Carol
On Feb 11, 2009, at 4:47 PM, Tom Lane wrote:
Carol Walter writes:
How do I install the tsearch module in 8.4? I have found
documen
Hello,
How do I install the tsearch module in 8.4? I have found
documentation on it's use, but it all seems to start with "After you
install the tsearch module..." It doesn't say how that is done.
Could someone tell me how it is done or point me to the appropriate
documentation?
Than
200 | 10 | 13 | f|
f | t | f | v |1 |
2278 | 25 || | |
set_curdict_byname | $libdir/tsearch2 |
(2 rows)
On Feb 6, 2009, at 2:35 PM, Joshua D. Drake wrote:
On Fri, 2
e R. wrote:
Does your user have their own SCHEMA, if so you will have to :
set search_path to SCHEMA_NAME
-Original Message-
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Joshua D. Drake
Sent: Friday, February 06, 2009 1:36 PM
To: Carol
Hello,
Should all functions be visible when I issue the command
citesrch=# select * from pg_proc;
including those that are user defined?
My user has several functions in his database that I don't see there.
I don't know if I'm looking in the wrong place or he dropped them
after the table was
t.
Thank you very much for your help.
Carol
On Feb 4, 2009, at 7:03 PM, Lee Azzarello wrote:
Can you perform queries against tables in that database? You may have
to poke around in the systems tables for the object ids in question.
-lee
On Wed, Feb 4, 2009 at 2:32 PM, Carol Walter
wro
Hello,
I'm getting this message when I try to back up one of my databases.
Is there something I can do about this?
bash-3.00# pg_dump -U postgres citesrch > /pgdump/citesrch_bk.sql
pg_dump: failed sanity check, parent table OID 131956046 of pg_rewrite
entry OID 131956048 not found
Thanks
I believe that this is dependent on what version of postgres you are
using. What you want to do is create a role. You do this by issuing
the CREATE ROLE command...
CREATE ROLE select_role;
GRANT SELECT on MyTable to select_role;
GRANT select_role TO MyUser;
Carol
On Feb 3, 2009, at 11:33
On Jan 22, 2009, at 1:27 PM, Ray Stell wrote:
On Thu, Jan 22, 2009 at 10:35:22AM -0500, Carol Walter wrote:
I'm still having problems with ssl. My ssl_ciphers line in
postgresql.conf
looks as the following:
ssl_ciphers 'ALL:!ADH:!LOW:@STRENGTH'
this parameter was not ava
I'm still having problems with ssl. My ssl_ciphers line in
postgresql.conf looks as the following:
ssl_ciphers 'ALL:!ADH:!LOW:@STRENGTH'
When I try to connect to the database from another system I get this
error...
walt...@cat:~$ psql -p 5433 -U walterc -d walterc -h db
psql: SSL SYSCALL
On Jan 21, 2009, at 4:24 PM, Ray Stell wrote:
On Wed, Jan 21, 2009 at 12:50:23PM -0500, Carol Walter wrote:
-bash-3.00$ /usr/local/ssl/bin/openssl verify -CAfile ./root.crt
testcert.pem
Error loading file ./root.crt
24149:error:02001002:system library:fopen:No such file or
x27;m wondering if that may be causing my problem. What should this be
set to?
Carol
On Dec 29, 2008, at 9:36 PM, Ray Stell wrote:
On Mon, Dec 29, 2008 at 04:23:30PM -0500, Carol Walter wrote:
"with openssl" when I initially configured the server. Are there
other
things that need
Hello,
If I need to rerun configure what else do I have to do. Do I have to
run gmake uninstall? Do I have to run gmake distclean? I've got a
running version of 8.3.4 (on Solaris 10) but I have to reconfigure so
postgres will know where the openssl bits are.
Thanks,
Carol
--
Sent v
. Do I have to back everything
out and run ./configure again? I don't see a parm in postgresql.conf.
Thanks,
Carol
On Dec 31, 2008, at 4:08 PM, Ray Stell wrote:
On Wed, Dec 31, 2008 at 11:16:42AM -0500, Carol Walter wrote:
On the web site you directed me to, the s_server command uses
Begin forwarded message:
From: Carol Walter
Date: December 31, 2008 11:16:01 AM GMT-05:00
To: Ray Stell
Subject: Re: [ADMIN] ssl database connection problems...
Sorry, I obviously am pretty clueless.
Thanks,
Carol
On Dec 31, 2008, at 10:09 AM, Ray Stell wrote:
On Wed, Dec 31, 2008 at
On Dec 30, 2008, at 8:42 PM, Ray Stell wrote:
On Tue, Dec 30, 2008 at 03:53:37PM -0500, Carol Walter wrote:
OpenSSL is telling me that ssl is
not properly configured.
how so?
Here's the output from s_client & s_server commands...
# openssl s_client
connect: Connectio
bout.
I'm running Solaris 10 and version 8.3.4 of postgres.
Thanks,
Carol
On Dec 29, 2008, at 9:36 PM, Ray Stell wrote:
On Mon, Dec 29, 2008 at 04:23:30PM -0500, Carol Walter wrote:
"with openssl" when I initially configured the server. Are there
other
things that need to be
Hello,
I've just created a new instance of postgres. It's running an a Sun
server running Solaris 10. I configured it with ssl using port 5433.
The server starts and runs. I can connect to it from the local host
and list the databases, connect to them etc. I can't connect to the
data
entified as the "libdir" in the arguments for ./configure
first, it works, if I put it at that end it doesn't.
Carol
On Dec 22, 2008, at 11:50 PM, Tom Lane wrote:
Carol Walter writes:
I just installed Postgres 8.3.4. I have an instance of 8.2.4 running
on the same box. Whe
t that
didn't work.
Carol
On Dec 22, 2008, at 9:43 AM, Carol Walter wrote:
Hello,
I just installed Postgres 8.3.4. I have an instance of 8.2.4
running on the same box. When I start psql I get errors as follows:
Welcome to psql 8.3.4 (server 8.2.4), the PostgreSQL interactiv
Hello,
I just installed Postgres 8.3.4. I have an instance of 8.2.4 running
on the same box. When I start psql I get errors as follows:
Welcome to psql 8.3.4 (server 8.2.4), the PostgreSQL interactive
terminal.
Type: \copyright for distribution terms
\h for help with SQL command
Is there a way to tell when the last time a database in a cluster was
accessed? I have a large number of student databases that are
probably inactive, but I don't want to just destroy. I'd like to
archive these, but I need to be able to tell when they were last
accessed?
Carol
--
Sent
Hello,
I have some databases that are designated as "SQL_ASCII" encoding. I
need them to be "UTF-8". I know that "SQL_ASCII" is really the
absence of encoding. Is there a way to do this?
Carol
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subs
Thanks. That will work. I hadn't thought of that.
Carol
On Nov 3, 2008, at 10:11 AM, Glyn Astill wrote:
From: Carol Walter <[EMAIL PROTECTED]>
I'm running PostgreSQL version 8.2.10 on Solaris 10.
How can I lock
everyone out except the postgres user?
Do it in pg_hba.
Greetings,
I'm running PostgreSQL version 8.2.10 on Solaris 10. How can I lock
everyone out except the postgres user?
Carol
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
I'm running on Solaris 10 and postgreSQL 8.2.10.
Thanks,
Carol
On Oct 24, 2008, at 7:47 AM, Helio Campos Mello de Andrade wrote:
On Thu, Oct 23, 2008 at 4:12 PM, Carol Walter <[EMAIL PROTECTED]>
wrote:
Greetings,
I'm moving files in preparation of loading them into the
Greetings,
I'm moving files in preparation of loading them into their appropriate
databases. I just ran out of space on my system before I got all the
files moved. I seem to remember reading some place that there is a
command that will go clean up after a successful postgres
installatio
te the files if your install was done from source.
4. Your install may be a package management step such as rpm, or you
may
require a "sudo make install" if your install was done from
source.
I hope this points you in mostly the right direction without begin
to long
winded.
Eva
Hello,
I'm doing an upgrade from 8.2.4 to 8.2.10. The documentation says,
"When you update between compatible versions, you can simply replace
the executables and reuse the data directory on disk." I guess I
don't quite understand what this means. Replace them by running some
parts of
Greetings,
I'm getting errors in gmake. What echos to the screen appears as
follows:
gmake[3]: Entering directory `/var/tmp/postgresql-8.2.10/src/
interfaces/libpq'
sed -e 's/\(VERSION.*\),0 *$/\1,'`date '+%y%j' | sed 's/^0*//'`'/' <
libpq.rc.in > libpq.rc
/bin/sh: libpq.rc: cannot creat
Greetings,
I'm trying to configure Postgres on a test box to I can the upgrade
my production box. I am getting an error as follow:
configure:17671: checking test program
configure:17686: gcc -o conftest -O2 -Wall -Wmissing-prototypes -
Wpointer-arith -Winline -Wdeclaration-after-statement -
r needed. I'm trying to understand what happens "under the
hood" so to speak. What checkpoint_settings value are you referring to?
Thanks,
Carol
On Sep 30, 2008, at 3:26 PM, Steve Crawford wrote:
Carol Walter wrote:
Greetings,
As you may be aware, we experienced a probl
Greetings,
As you may be aware, we experienced a problem last week with pg_clogs
that had been deleted, through human error it appears. What process
will clear or delete the pg_clogs? I've been all over the
documentation and I'm not finding a reference to this.
Thanks, in advance,
Caro
Well, it was a bit convoluted, but I created the file with Excel,
filling the right number of cells with \x55. This worked too. The
script wouldn't run for me. I got an error about a "bad interpreter".
Carol
On Sep 25, 2008, at 1:40 PM, Steve Crawford wrote:
Scott Marlowe wrote:
I used
Hello,
I'm not quite out of the woods yet, but I think I'm close. Here's
what I've done. There were some databases that were not effected by
the loss of the pg_clog files. I created a script than ran pg_dump
on each database while the files were missing. Then I created the
files that
Hello,
Does anyone know what the format of hex characters for postgres are?
I'm trying to create files that contain a 0x55. It looks to me like
it should require a delimiter of some sort between the characters. I
don't know how postgres would know that the string was a hex
representati
To use the hex value 0x55, do I need to enclose it in single quotes?
Carol
On Sep 24, 2008, at 11:44 AM, Tom Lane wrote:
Carol Walter <[EMAIL PROTECTED]> writes:
Are the files that contain the hex characters supposed to contain a
single string and no control characters?
Yes, you wan
create the dummy files, and pg_dump
works, I could restore an old pg_dumpall file and then insert any
data that aren't there from the pg_dumps.
Carol
On Sep 24, 2008, at 9:10 AM, Tom Lane wrote:
Carol Walter <[EMAIL PROTECTED]> writes:
I tried creating the files through
| 524
walterc | 524
msinghi | 524
(301 rows)
Thank you for all your help.
Carol
On Sep 24, 2008, at 9:10 AM, Tom Lane wrote:
Carol Walter <[EMAIL PROTECTED]> writes:
I tried creating the files through 002F. Pg_dump still wil
Hello,
I tried creating the files through 002F. Pg_dump still will not
run. The error was as follows:
-bash-3.00$ pg_dump -U postgres ebiz > ebiz_bk.sql
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: could not access status
of transaction 20080015
DETAIL: Co
I've had no system crashes. I'm embarrassed to say that I may have
inadvertently caused this problem when I was do "house cleaning" a
couple of weeks ago.
When I upgrade, how to I get my data when pg_dumpall won't run?
Carol
On Sep 23, 2008, at 10:42 PM, Tom L
Hello,
Here are the pg_clog files I still have.
-rw--- 1 postgres postgres 262144 Jun 4 18:43 0030
-rw--- 1 postgres postgres 262144 Jun 6 02:06 0031
-rw--- 1 postgres postgres 262144 Jun 7 01:26 0032
-rw--- 1 postgres postgres 262144 Jun 7 21:26 0033
-rw---
ECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of Carol Walter
Sent: Tue 9/23/2008 2:31 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Missing pg_clog files
I'm missing about 30 pg_clog files. How do I recover from this?
Carol
--
Sent via pgsql-admin mailing list (
I'm missing about 30 pg_clog files. How do I recover from this?
Carol
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
There really is not pg_clog/0009 file.
On Sep 23, 2008, at 4:50 PM, Scott Marlowe wrote:
On Tue, Sep 23, 2008 at 2:48 PM, Carol Walter <[EMAIL PROTECTED]>
wrote:
Hi, Folks,
What would cause this error?
SQL error:
ERROR: could not access status of transaction 10274530
DETAIL: Cou
Hi, Folks,
What would cause this error?
SQL error:
ERROR: could not access status of transaction 10274530
DETAIL: Could not open file "pg_clog/0009": No such file or directory.
Carol
;. Is there another way I
can isolate what's happening?
Carol
On Sep 18, 2008, at 5:01 PM, Tom Lane wrote:
Carol Walter <[EMAIL PROTECTED]> writes:
Postgres. To do this, I did a pg_dumpall and I'm restoring. I got
an error on the restoration as follows:
psql:/dbsdisk
Greetings one and all,
I am porting all my databases from a 32 bit Postgres engine to 64 bit
Postgres. To do this, I did a pg_dumpall and I'm restoring. I got
an error on the restoration as follows:
psql:/dbsdisk/data_load/dbdev_all_080915.sql:3920581: WARNING:
column "collection" has
.
Barbara
Anibal David Acosta wrote:
MICRO-OLAP Database designer for postgres is a great tool.
-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] En nombre de Carol Walter
Enviado el: lunes, 15 de septiembre de 2008 02:58 p.m.
Para: Thomas Jacob
CC: Barbara Stephenson; p
This sort of depends on what you want to do with the ERD. If I want
to document an existing system, I use Aqua Data Studio. It's not
free, but it will take an existing system and draw the ERD for you
based on the relationships it finds in the database. There are
things that I don't like
Hello,
We're building a test box for our webmaster to play in. It needs to
have the same config as his production box. The postgres default
data directory doesn't match the location of the data directory
location on the production box. The postgresql.conf file has the
line that says th
have been using Migration
Studio from Enterprise DB (which is part of the Advanced Server
install). Also, with MySQL 5.0 and above they have some conversion
tools that do come with the install to assist you.
On Thu, Sep 4, 2008 at 9:24 AM, Carol Walter <[EMAIL PROTECTED]>
wrote:
That's a good idea. I think I'll try that.
Carol
On Sep 4, 2008, at 1:18 PM, H. Hall wrote:
Carol Walter wrote:
Hello, All,
I have a new faculty member who has a large database that is in
MySQL. We don't support MySQL so the database needs to be ported
to PostgreSQL. H
According to the GA, the database has 1,000,000 rows. I hesitate to
pass that along because I don't know what that means. It strikes me
as an odd way to talk about a relational database. Normally, a
relational database has more than one table, so how is a "database"
having a million rows
Well, my database server lives on a Solaris 10 box. I'm running
PosgreSQL 8.2.3. The database that is being converted from MySQL is
currently on a Windows machine. So far it seems that every solution
involves an interim step or two. I think he was alluding to just
running a query.
Car
Hello, All,
I have a new faculty member who has a large database that is in
MySQL. We don't support MySQL so the database needs to be ported to
PostgreSQL. Her GA, who know MySQL, says that he has a query that he
will run that will put the data into postgres. I thought that the
data wo
icate that it was only necessary in certain cases. This
didn't seem to fit my circumstances.
Anyway, thanks for your help.
Carol
On Aug 28, 2008, at 4:51 PM, Richard Broersma wrote:
On Thu, Aug 28, 2008 at 1:49 PM, Richard Broersma
<[EMAIL PROTECTED]> wrote:
On Thu, Aug 28, 2008 a
Hello,
I asked this question yesterday, but perhaps I did so in an
unintelligible way. I didn't get any answer that time. Someone
usually answers my questions, so I must not have asked it very well.
I have a new database that I'm building for a faculty research
project. I created a ro
hanged the privileges on my
personal database to match the ones on this research database and I
can still see and browse those tables. Any ideas?
Thanks,
Carol Walter
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.or
If I understand your question, you might need to turn up
log_min_messages to debug1 otherwise you won't see the relations. I
had the system set to autovacuum and I couldn't see that it was doing
it until I made this change.
Carol
On Aug 26, 2008, at 3:09 PM, Jeff Frost wrote:
Looks like
Greetings, one and all,
I have some very large memory bound queries being run in postgres.
The documentation seems to say that I would be able to get more use
out of the available memory if I were running the 64 bit postgres
instead of the current 32 bit. We have the binaries for both. W
ocation so that faculty won't have to change they're
instructions to students.
Carol
PS Again, My OS is Solaris 10.
On Aug 14, 2008, at 5:21 PM, Reed Loefgren wrote:
Carol Walter wrote:
I'm running Solaris 10. I'm not sure whether I'd compile source
or use pack
t to put this back where the earlier one was, if I
can. The faculty have syllabi that have paths and links in them that
will confuse the students if things aren't where they expect.
Carol
On Aug 14, 2008, at 3:34 PM, Steve Crawford wrote:
Carol Walter wrote:
Hello,
I want to do a new
running on different servers. If
this is anything like everything else I've seen there, quite
possibly, is a different customization for each server.
Thank you very much,
Carol Walter
1 - 100 of 174 matches
Mail list logo
