Server :: Can't View PostgreSQL Table Data?

Dec 10, 2010

For some reason I am unable to view my database tables for my Wiki & I can't understand what I am doing wrong or what I'm missing. I know for sure there's table data on my 'wiki' database but for some reason I don't know how to list it.

Code:
psql (8.4.5)
Type "help" for help.

[code]....

View 1 Replies


ADVERTISEMENT

Server :: PostgreSQL Can't Rename Table Constraints?

Apr 9, 2011

I had to rename a table yesterday due to a contact / group name change in the office and sadly I'm the only person who knows how to barely interact with SQL due to my years as a Linux Administrator. Renaming the table was simple:

Code:
iamunix=# ALTER TABLE accounts RENAME TO marketing;
ALTER TABLE

[code]....

View 2 Replies View Related

Server :: Can't Insert A Record In A Table On Postgresql Database?

Sep 2, 2010

my database (PostgreSQL) has ever funtioned OK, but today don't let me insert a new row in a table and the record itsn't duplicated. I did a vacuum full and reindex the database and the problem continue. I don't know what the fuck is happening

View 2 Replies View Related

Server :: Removing Old Table Data From MySQL?

Jul 6, 2009

When a user logs into my webmail application, it creates entries in a table on MySQL called "identities" which works great however once the user is deleted fro Linux with the "userdel -r" command, the data still sits in MySQL. My question is how I can I remove the table data from old users? It appears as show below:

[code].....

View 1 Replies View Related

Server Platforms :: Partition Table Deleted - Get My Data Back Safe Without Losing It ?

Mar 6, 2010

I've initialize a virtual disk and deleted the partition table didn't notice that i've done that to the wrong one, data still on the physical hard disks but....how I'll get my data back safe without losing it?

View 4 Replies View Related

Ubuntu Servers :: Recovering Data From Old PostgreSQL Install

May 5, 2010

I was previously running postgresql 8.3, but upgrading to Ubuntu 10.04, has installed postgresql 8.4 and I'm now unable to start 8.3. I don't mind using 8.4, but I need to recover the data from my 8.3 installation, But I'm not sure how to do this as I can't start the 8.3 server, and 8.4 can't read my old data directory.

View 2 Replies View Related

Software :: Postgresql 8.47.on Debian/ Gnu Squeeze-stable. Imporitng Data?

Apr 15, 2011

I imported one table from a csv file format with no problems. The file fields where matching my table fields. For a second table import (I will use a similar example to simplify: So I created a table with the following fields: Contactname addr city zipcode the file to import has the following fields Contactname firstname middlename lastname addr city zipcode.

[Code]...

View 1 Replies View Related

General :: Networking - Doesn't Respond To Pings - View The Arp Cache Table?

Jan 20, 2011

I have a Slackware 13.0 server that is not replying to icmp pings. However, I have double checked that /proc/sys/net/ipv4/icmp_echo_ignore_all is set to 0. The weird thing is I can run nc -v slackware 22 from any computer on my lan and the banner comes up just fine. The nic is on the same netmask and broadcast as all the other computers on my lan. I can log into it as well, it just doesn't respond to pings. I can even ping other computers and get replies just fine when pinging from inside the Slackware server.

I have even added an iptables INPUT rule for -p icmp -j ACCEPT. Although I've never had to do this. I ran tcpdump -vv icmp and I can see ping requests coming into the computer, however slackware simply doesn't respond. What could be causing this? A corrupt arp cache? It's been happening for more than a few hours so I wouldn't think so. How can I view the arp cache table? How do I clear it?

View 5 Replies View Related

Programming :: Getting Table Data From Web Pages?

Jul 18, 2011

I am writing a program and I need to be able to grab data from web pages.The data I am looking for is on wiki pages with basic tables.A simple example would be like grabbing all of the episode data from a TV show of something similar.

View 5 Replies View Related

General :: Partition Table Raw Data Using Fdisk

Apr 27, 2010

had trouble viewing partition table using fdisk, now realised i just cudnt view the whole table from Rescue terminal, please remove this thread, i can't find how ))

View 1 Replies View Related

Programming :: Output Data To An Ascii Table?

Oct 18, 2010

I've got lines of data in the following format:
space1=number of times error has occured
space2=IP address
space3=Error

I've set this out nicely with printf and made it email me, the problem is - it's not entirely clear what each column/space is and the IP and occurances can sometimes seem confusing. Is there any (easy) way to output this into an ascii like table? There will always be 5 occurances, and the format will always be the same

View 1 Replies View Related

Ubuntu :: Simply Edit Table Data For MySQL Db?

Feb 18, 2010

I have tried a few packages but cannot find an easy intuitive interface for editing tables in a mySQL database. I just need to simply edit the table field data, import and export multiple rows, and filter the table data so only the rows are returned based on a string that I search for. The tables I edit have several thousand rows and some up to 30,000. I do not know how to write queries and it seems all these packages require that you know how to write sql queries to do what I need to do. On the mac I used Sequel Pro, which is dead easy to use and is mostly point and click to do all the above. Since my mySQL experience is very limited, I really need something simple like this.

I have tried:

MySQL Workbench
Navicat (lite version)
MySQL Query Browser

how to do what I need to do with the above packages.

View 7 Replies View Related

Ubuntu :: Output Data From Text File Into A Table?

Apr 13, 2010

I'm having a slight dilemma on reading data from a text file and outputting it into a table then displaying it. Basically I'm writing a shell script that takes information from text files then outputs the data into a table with 4 headings. The extracting of the data is fine, but creating a table i'm having problems with. My code extracts the data outputs the string to another file which works fineThe text file looks like this

mr smith 1 purchase oct 2007
mrs smith 2 purchase nov 2006
i want it to look like this

[code]....

View 7 Replies View Related

Hardware :: Restore Partition Table Or Recover Data?

Mar 27, 2009

I was putting the cover back on my Antec p180b, and I guess it got stuck and gave it a hard bump (pretty much broke the cover). As a result, one of my hard drives, a Seagate Barracuda ST3750640AS, got messed up or something. All the other hard drives are fine. It's in an LVM with another hard drive, so now I can't boot up into my computer. So I booted into the installation CD:

Code:

# find /dev/sd[a-c][1-3]
/dev/sda1
/dev/sda2

[code]....

This led me to believe the partition was messed up. So I ran cfdisk, and it said something about a missing partition table or something. Additionally, instead of showing the single partition on it, it displays, from my recollection, Pri*Log. To my knowledge, this is the only problem with the hard drive. So now I need to either somehow create or restore the partition table without overwriting the data. Or get a new hard drive, and some how recover the data (LVM, partitions, and all).

View 4 Replies View Related

Programming :: Copying Data To Clipboard Using OSF/Motif, C++, And XRT Table?

Dec 23, 2010

I am working on an application in Motif and C++, which uses an XRT Table. With the XRT Table being an infrequently used product, it is hard to find good documentation on it, and one area in particular is sorely lacking... a good explanation on how to copy text from the table to the clipboard used by other X11 applications. I've come across an example application that demonstrates how to copy text to the clipboard, but I cannot seem to merge that knowledge with what I'm provided with the XRT Table API. Does anyone have any knowledge in using the XRT Table, and in particular, with copying selected fields within the table to the clipboard?

View 3 Replies View Related

Ubuntu :: Recover Data From RAID 1 Where Partition Table Has Been Deleted?

Jan 12, 2010

I have 8.04 running mdadm raid 1. I selected the wrong drive in gparted and managed to hose my partition tables.

View 7 Replies View Related

Ubuntu :: Fixing A Deleted Partition Table / Data Recovery?

Jan 27, 2010

I erased my partition table. Can anyone recommend a good method of reconstructing it? And if this is impossible, can anyone recommend a good method of data recovery? I had an ntfs partition with windows 7 and a larger ext3 partition that ran Debian.

I'm running Test-disk on the SystemRescueCD at the moment (cross your fingers).

View 1 Replies View Related

General :: Read Data From Text File And Output Into A Table?

Apr 12, 2010

I'm having a slight dilemma on reading data from a text file and outputting it into a table then displaying it. Basically I'm writing a shell script that takes information from text files then outputs the data into a table with 4 headings.he extracting of the data is fine, but creating a table i'm having problems with. I think it is possible to do it using the awk function, but so far i'm having a lot of difficulties.

View 14 Replies View Related

Software :: Repair Missing Partition Table And Recover Data From Xfs?

Jun 15, 2009

I used to have a 1TB external drive with lots of stuff on it. But after a reported drive failure during a F11 install the partition table seems to have been lost. (I think F11 toasted it)

Disk /dev/sdc: 1000.2 GB, 1000215724032 bytes
255 heads, 63 sectors/track, 121602 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

[code]....

The drive used to have xfs and a partition. Is there any way to rebuild the partition? Or is my 1TB of data gone forever? The drives seem to be fine now... I just want to get it up enough to either pull any data or just to get a file list. Most of the stuff on the drive was from somewhere else.(ie 300GB of NRN data for all of North America.

View 3 Replies View Related

Programming :: Perl: Compare CGI Input With Data From A MySQL Table?

Nov 19, 2008

I have this program:

#! /usr/bin/perl
use DBI ;
use strict ;

[code]....

and I get this error simply running the program from the command line: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ./submit.cgi line 24.

is this the right syntax to use, both, for this line:

my (@param) = $cgi->param("firstname","lastname","type") ;

as well as this one:

$sth=$dbh->prepare ("SELECT firstname,lastname,type FROM dts WHERE firstname LIKE $param[0] AND lastname LIKE $param[1] and type LIKE $param[2]" );

or should there be quotes around the $param[0] or something? (also is it $param[0] or $param(0)?)

View 1 Replies View Related

Programming :: Arrays In Awk - Take Some Data From A File - Ssh Log - And Print It To A Html Table

Feb 7, 2011

I have a problem with arrays in awk. What i want is to take some data from a file (ssh log) and print it to a html table. I have managed to print some stuff (user logged in and how many times they have logged in) What i want more is to take all the ip that each user logged in from and print it in a row next to the username and times (in the code i typed blabbla where i want the ip to be shown. How do you think i should approch that, multidimensional arrys maybe?

Code:

View 14 Replies View Related

General :: How To View Raw Data

Jun 7, 2011

Does there exist a program for Linux that can display raw binary data?

Each byte in my binary files represent a pixel, so it would be very useful if something like this exists where I could say

program_name --input=dat001.bin --width=200 --height=100

and it would display the pixels.

View 2 Replies View Related

Fedora Installation :: Broken Partition Table - Cause Significant Data Corruption ?

Jul 24, 2009

During a recent request to install fedora 11, I ran into an interesting problem. It seems that between fedora10 and fedora11, the developers switched from fdisk, to parted for creating the initial pre-mke2fs partition table creation.

It looks like the implementation of this is broken, as it's writing the partition table with overlapping cylinder boundaries. While this can sometimes be ignored, it can in certain cases cause significant data corruption.

On an installation I took it through, using the latest installation media, in both manual & automatic partition creation, the layout looked like this:

The last two partitions turn out fine, for some reason. However, those two partitions should not have overlapping cylinders. After my very first installation, the system was completely unbootable, and not even fsck wouldn't rescue it. If this is possible, then that means that a system that's been online for months or even years could simply drop out of functionality simply due to a byte or two of system-critical data falling on that last cylinder. Considering that a lot of the time kernel data ends up on /dev/sda1 (commonly the /boot partition), this is something that should not be ignored.

View 4 Replies View Related

Ubuntu :: Crawling Online Database And Placing Specific Data Into A Table?

Jun 12, 2010

I want to download some specific information(age of the building, value, square feet, etc.) from a county auditor's website:[url]

For every property in the county and ultimately match it to a .dbf file I already have containing geographic information for each parcel.

The website only displays information for a single address at a time in response to a query form asking for either the parcel ID# or street address. I have a table of all the county's parcel ID#'s and valid addresses-about 350,000 or so of them.

I imagine there must be some way to automatically crawl the website inputting the information from my tables into the form and gathering specific information in some sort of format that could then be matched to corresponding information in my .dbf file.

View 1 Replies View Related

General :: Can't Format Kingston 8GB Data Traveller G2 - Fix Partition Table Back?

Oct 25, 2010

I used a Kingston 8Gb flash drive as a live usb recently (copied the live iso image over using dd). I am done with the installations and all but seem to have a problem. i cannot format my flash drive. It now shows as a live CD (800 or so mb). Is there a way to fix the partition table back? I guess if i copy a partition table image from some other 8 gb drive that might fix the problem but i dont have any other flash drives. Is there a solution possible or am i stuck with a live usb forever

View 1 Replies View Related

General :: Program To View Data In Memory RAM?

Aug 5, 2011

I'm running a java program and to debug the program instead of using a debugger I would like to look to the heap and to the bytes in the memory of the process. I was hoping that the pointers would give me a snapshot of a moment of the application. It exists a program that allow us to look to the details of a process and to the memory ram?

View 2 Replies View Related

Server :: Postgresql-8.4 Server Doesn't Listen / Fix It?

Nov 23, 2010

I'm getting some problems setting up a Postgresql-8.4 server (using Debian Lenny).
After have installed the PGSQL server, I've changed the following files as bellow code...

If you encounter this message, please check if the server you're trying to contact is actually running PostgreSQL on the given port. Test if you have network connectivity from your client to the server host using ping or equivalent tools. Is your network / VPN / SSH tunnel / firewall configured correctly?
For security reasons, PostgreSQL does not listen on all available IP addresses on the server machine initially. In order to access the server over the network, you need to enable listening on the address first.
For PostgreSQL servers starting with version 8.0, this is controlled using the "listen_addresses" parameter in the postgresql.conf file. Here, you can enter a list of IP addresses the server should listen on, or simply use '*' to listen on all available IP addresses. For earlier servers (Version 7.3 or 7.4), you'll need to set the "tcpip_socket" parameter to 'true'.
You can use the postgresql.conf editor that is built into pgAdmin III to edit the postgresql.conf configuration file. After changing this file, you need to restart the server process to make the setting effective.
If you double-checked your configuration but still get this error message, it's still unlikely that you encounter a fatal PostgreSQL misbehaviour. You probably have some low level network connectivity problems (e.g. firewall configuration). Please check this thoroughly before reporting a bug to the PostgreSQL community.
This is the same configuration that I have in other Lenny server, which works well.

View 2 Replies View Related

Security :: View Random Data And Zeroes On A Hard Drive?

Mar 9, 2011

I want to view a hard drive and see if it has all zeroes, how would I do this? I want to view a hard drive and see if it has all random data, or random data mixed with zeroes. How can I do this? I prefer to do all this in linux if possible without a gui...so looking for any cli tools to view with.

View 5 Replies View Related

Server :: Cannot Create Database In PostgreSQL

Dec 26, 2010

i installed Fedora 14 on my machine,then i installed postgresql in it i started it and configured it after seeing link [URL] i am able to do su - postgres but when i am trying to create database in it am getting error,It is asking for password then i am giving my root password

createdb company
Password:
createdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres"

View 1 Replies View Related

Server :: Postgresql Runs In Multiple Pid?

Jul 19, 2010

when i give service postgresql status command. i get the following.ostmaster (pid xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx) is running...The issue is my postmaster service is running in multiple process ids.As a result my cpu usage becomes high.How to resolve this. my postmaster service need to be run under only one process id

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved