Hello everyone,
We have PostgreSQL 8.1.21 on CentOS 5.5 and some of our older programs still
use OIDs to identify a row. I'm planning on adding a serial column to the
tables and modifying the code to use the serial column instead. But I am
curious to find out how close we are before the OID w
On Sep 29, 2010, at 7:56 PM, Tom Lane wrote:
> pg_controldata would tell you approximately where the OID counter is.
Just what I needed. Thank you so much Tom.
Dianne
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgr
Hello,
I have some html forms that I save the settings into the database,
things like which item was selected in the menu and if a checkbox was
checked. The table looks like this:
user_id | report_id | info
-+---+
First, I want to thank you for your help. You have made great points
and I just want to respond to some of your questions.
My first thought is that if you use a combined "info" field, you'll
lose the ability to easily do any kind of meaningful data analysis
based on which boxes are checked. I
which webserver does your client want to implement?
Apache, sorry I forgot to mention.
If JSLibrary = Dojo I would look at JSON (JavaScript Object
Notation language)
I would serialize to JSON instead of XML.
http://www.aurore.net/projects/php-json/
A simple json_encode($_POST) might do th
Would an EAV model work? I'm thinking something like
. For example:
formA,ckbox1,true
formA,input1,initial value
formB,textarea1,enter your long comment here
You could easily extend this to , or
normalize it as you see fit.
This would work great too. If we go this route, we'll keep it simpl
Why don't you try yum, it will install the dependencies for you ; )
http://linux.duke.edu/projects/yum/
On Mar 18, 2005, at 11:32 AM, Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 18 Mar 2005, Edgar Amorim wrote:
I'm a kind new bye with linux & related stuffs. I'm t
Yup, I didn't see your email off-list till after I re-sent the other
email. But thanks for the info.
On Mar 18, 2005, at 11:56 AM, Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 18 Mar 2005, Dianne Yumul wrote:
Why don't you try yum, it will i
Sorry, I did not see your email off-list until after I sent the other
one.
On Mar 18, 2005, at 11:56 AM, Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 18 Mar 2005, Dianne Yumul wrote:
Why don't you try yum, it will install the dependencies for you ; )
Hello list,
We have Fedora Core 4 Test 3 installed on a development box and just
recently installed Postgresql 8.0.3. Sometimes, when starting
postgresql with the /etc/rc.d/init.d/postgresql script, it gives me the
following:
/usr/bin/chcon: can't apply partial context to unlabeled file
/ho
used to
have 8.0.2 installed but I upgraded to 8.0.3, hoping that would fix it
but it didn't.
Thank you.
Dianne
On Jun 6, 2005, at 8:00 PM, Tom Lane wrote:
Dianne Yumul <[EMAIL PROTECTED]> writes:
We have Fedora Core 4 Test 3 installed on a development box and just
recentl
tmaster -p 5432 -D /var/lib/pgsql/data
Many thanks for the help.
Dianne
On Jun 7, 2005, at 9:02 AM, Tom Lane wrote:
Dianne Yumul <[EMAIL PROTECTED]> writes:
Um, exactly which Postgres RPMs do you have installed?
Thanks for the response. I have the following installed:
post
ll the help.
Dianne
On Jun 7, 2005, at 10:58 AM, Tom Lane wrote:
Dianne Yumul <[EMAIL PROTECTED]> writes:
# rm -f pgstartup.log
# /etc/rc.d/init.d/postgresql start
/usr/bin/chcon: can't apply partial context to unlabeled file
/home/postgres/pgstartup.log
Starting postgresql service:
Just an update . . . I tried upgrading kernel to 2.6.11.11 (kernel.org) but was unsuccessful (due to i2c and gcc 4.0 issue). So I settled for the one on the fedora development repository. But that didn't help, upgraded other stuff too like selinux-policy-targeted and initscripts. Beginning to pull
Here:
http://www.postgresql.org/ftp/binary/v8.0.3/linux/rpms/fedora/fedora-core-2/
If you go to www.postgresql.org, under Downloads, you'll find directions and a link to the FTP mirrors.
On Jul 15, 2005, at 7:38 AM, Dinesh Pandey wrote:
From where can I download?
“Postgres 8.x” + required pac
oh, and for installation instructions, please check out the very fine documentation at:
http://www.postgresql.org/docs/8.0/interactive/index.html
: )
On Jul 15, 2005, at 7:38 AM, Dinesh Pandey wrote:
From where can I download?
“Postgres 8.x” + required packages and “installation instruction”
Hello,
We have Fedora Core 4, but I'm pretty sure it's the same. To start the
service we use
/etc/rc.d/init.d/postgresql start
Now if you want postgresql to start automatically on boot you do:
chkconfig postgresql on
Read the man pages for chkconfig for more details.
Hope this helps.
On A
May be you want the FM prefix, i.e. to_char(current_timestamp,
'FMMonth'). See the docs for more info:
http://www.postgresql.org/docs/8.0/interactive/functions-
formatting.html#FUNCTIONS-FORMATTING-EXAMPLES-TABLE
On Sep 19, 2005, at 8:20 AM, Alex Turner wrote:
Shiver me timbers, whats up w
Hello to everybody.
I just have a couple of newbie questions. I'm trying to restore our
databases from a file system backup. The backups are done with rsync,
the postgresql service is stopped before backups are done on the
server. The system is Fedora Core 4 with Postgresql 8.0.3.
Now back
Args looks like this:
pg_dump -Ft -b -v the_db_name > the_output_file.tar
pg_restore restores the database. i.e.:
pg_restore -d the_db_name the_output_file.tar
Hope this helps -
Scott
On Nov 10, 2005, at 2:41 PM, Dianne Yumul wrote:
Hello to everybody.
I just have a couple o
Thanks for the response.
does the global directory exist on the drive you are syncing from? If
so ...
then it's a problem with your rsync.
check the options you are using with the rsync command.
check the rsync configurations in /etc/rsyncd.conf on the drive.
what user are you running the rsy
Hello list,
I downloaded the 8.0.10 rpms for FC4 yesterday and after installing
it, postgresql won't start. I get the following error: "An old
version of the database format was found" My previous postgresql
version was 8.0.8 and I read nothing on the release notes about a
dump/resto
hi,
I think it works for me. what version of postgres do you have? maybe
you just need to upgrade : )
test=# select cust_id, 'TEST' as test, cust_address from customers;
cust_id | test | cust_address
+--+--
11 | TEST | 200 Maple Lane
100
23 matches
Mail list logo
